Duplicate Records

[nbrown]

How do I go about finding records that exist more than one time? For some reason when I was importing a txt file it duplicated records instead of updating them.. Even tho I had the ID set on "Unique" and "Strict" it still allowed them to duplicate the ID numbers. There are alot of them so is there an easy way to pull up any records that exist more than once?

Thanks in advance!

Nic

[andygaunt]

Hi,

If you do a find and add an ! in the field that will find where the information is repeated in more than one record.

You can then sort by this field to bring them all together.

[Keith M. Davie]

Andy Gaunt,

[Paulr81755]

Is there an easy way to eliminate dups and keepint the original? Thanks

[glaser_david]

First you need to have a way of differentiating the original from the duplicates. Maybe it is the creation date of the record....

Then, there is an example in the fm 5.5 manual p 10-13 where they teach you how to find and mark duplicates. This is done using a global field, with all the records being sorted on the field you want to find the duplicates. once duplicates are marked, you can export them, or delete them.

[Paulr81755]

Yes, I am aware of this method, but it can be complicated. Is there any other simpler way to find duplicates and delete all but the one you wish to keep? Thank you very much. Paul

[BobWeaver]

The script solution in the manual is probably the simplest one you will find.