U.M. (Windows)

5-28 FileMaker Pro User’s Guide
When you perform the Find Duplicates script:
1. It finds all records, and then sorts them by the ClientID field so that
records with the same ClientID are grouped together.
2. Starting with the first record, the script copies the value from the
ClientID field into the Global field.
3. The script goes to the next record and compares the value in ClientID
with the value in Global.
1 If the values match, the record is a duplicate and the script puts an
x in the Mark field.
1 If the values don’t match, FileMaker Pro copies the ClientID value
into Global. It doesn’t change the Mark field.