Jump to content
Sign in to follow this  
nbrown

Duplicate Records

Recommended Posts

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 tongue.gif

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.