AnsweredAssumed Answered

Find and Delete Duplicates

Question asked by SchoolData on Sep 17, 2013
Latest reply on Sep 17, 2013 by philmodjunk

Title

Find and Delete Duplicates

Post

     http://help.filemaker.com/app/answers/detail/a_id/3441/~/finding-and-deleting-duplicate-records-in-filemaker-pro

     This article looks promising, but it does not work for me. It does not mark an X anywhere. When I use ! in Find, it returns all the duplicates and if I delete all of them, I loose the record I want. I only want to keep one record if there are two or more with duplicate values for the field. 

     I attached a screenshot of my script.

Screen_Shot_2013-09-17_at_2.48.13_PM.png

Outcomes