Find Unique Field Values and Delete All Others

[tbfilemaker]

My database has several records with duplicate values for one field. I need to find the unique value for that one field and Delete All others.

Example: I have a PO # 1234 for Record #1, PO # 1234 for Record #2 and PO # 1234 for Record #3. My goal is to find PO # 1234 and Delete All the other PO # 1234s. The catch: I have several different PO #s that are duplicates, ultimately I need to get one unique set of PO #s.

Any tips or pointers would be greatly appreciated, thanks in advance.

[BobWeaver]

There are a number of posts about this topic. And most notably the basic script example given in the Filemaker User manual covers this exact situation. Look at the script example at the end of chapter 10.

[tbfilemaker]

Thank you kindly.