AnsweredAssumed Answered

How can I manage duplicate records in Filemaker

Question asked by dcoats on Sep 10, 2010
Latest reply on Sep 10, 2010 by philmodjunk


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', " "]
Set Field['Global','ClientID']
Go to Record/Request/Page [Next, Exit after last]
If ['Global = ClientID']
Set Field ['Mark', '"X"']
Set Field ['Global','ClientID']
End If
End Loop
Perform Find [Restore] Find records when Mark = X