Looping to find unique record

[Carl Smith]

I am familiar with looping through a found set of records to find a duplicate entry but am baffled when trying the opposite - looping to "mark" the unique entries.

Can anyone advise?

[VICH]

are you sorting underthe basis that you know that there is a duplicate and you want to find it or are you checking for any duplicates

[Carl Smith]

Known duplicates exist.

[VICH]

you could have a script that does a find for the info on the duplicated records and at the end of the script have:

go to record request first (or last which ever you want)

set field (duplicatecheck : " " )

the trick that i use is i make a field like duplicate check that i define a valuelist to and that value list is just a typed space. then whati do is set it as a check box and just the box shows up and you tell the script to set that check box field to " " and it will put a check in there for you

if that doesn't make sense email me at [email protected] and i will send you a sample file

[BobWeaver]

Why not use the ! symbol to search for duplicates and then do a Show omitted command. Your found set will then contain only unique records.

[VICH]

i don't know if he wants to just view them or mark them for viewing them that would work great if he wants to mark automatically mine would work as well

[-Queue-]

If you want to mark all unique records, regardless of whether there are duplicates for them, you can create a self-relationship based on a concatenation of the fields which determine uniqueness (field1 & " " & field2 & " " & ... & " " & fieldN) and then use a calculation field of Relationship::serial = serial. All unique (original) records will then contain a 1 in this field. All duplicates will contain zero.