Find duplicate records ?

[JohnW]

I have FMPro 4.1 on my office PC that runs a simple single file/single screen DB. Due to some file merging I have some number of duplicate records. Each record has a "work order" number. I want to have a search that finds all the duplicates so I can kill the older version. How is that done ?

JohnW

[Vaughan]

Change into find mode. On the status bar there is a pop-down list or menu with symbols: select ! to search for duplicates.

Note that this finds all duplicates -- that is, if two records have the same value it finds *both* of them. So don't delete them all, scroll through and delete the extras.

[JohnW]

Thanks, I'll give that a try .

JohnW

[Arin]

Is there a script command for the "!" function?

-a

[BobWeaver]

Enter Find Mode [no restore]

Set field [theField, "!"]

Perform Find [no restore]