Script for identifying only one record.

[mamawong50]

In table view I have similar information sorted by ID#. I need a script that will identify the first record of each set of similiar ID numbers. Those identified records will become a "found" set.

ID #-------- Name-----------Field3

234567--- John Smith---blah..blah

[Ugo DI LUCA]

Hi,

You need a flag for duplicates. Check this thread which is one of my favorite on the topic

Calcing a field to purge duplicate

You won't need to purge it, but you'll see the calcs, and may be some more infor fot the future...