Filemaker Pro – Finding Duplicate Records

The “!” character is the symbol for locating duplicate records in the database.


1. Enter Find mode.


2. Go to the Asset Tag field and enter an exclamation point by itself. Hit Return.


3. Results are anything with a duplicate.


This is useful for post-import cleanup. These duplicates should be flagged.

Posted in: Applications, Inventory