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?

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

Known duplicates exist.

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

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.

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

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.