Jump to content

Duplicate Records


nbrown
 Share

This topic is 7128 days old. Please don't post here. Open a new topic instead.

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

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

This topic is 7128 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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