How can I manage duplicate records in Filemaker
I went to the knowledge base and found the following script but I can't get it to perform what I need. It returns errors. Primarily in Manage Scripts, how do I make it set the Mark field with an X? Also, How does it know to go to the previous records and compare that Global field to the ID of the current or next field?
Any help on how to manage and mark duplicates is appreciated.
Show All Records
Sort Records [Restore, No Dialog] Sort by Client ID in Ascending order
Go to Record/Request/Page [First]
Replace Field Contents [No dialog, 'Mark', " "]
Go to Record/Request/Page [Next, Exit after last]
If ['Global = ClientID']
Set Field ['Mark', '"X"']
Set Field ['Global','ClientID']
Perform Find [Restore] Find records when Mark = X