Newbies endoskeleton Posted November 17, 2006 Newbies Share Posted November 17, 2006 Hi, I have just started using File Maker Pro 8 and have been battling with a problem for about 6 hours. I know how to find duplicate records in my client database, based on name, address, post code etc, but is it possible to ask File Maker to omit the first record found. This will enable me to delete all of the found set leaving just one record for each client. I would do it my hand but there is 40,000 records to go through. Any and all help is appreciated. Many thanks Link to comment Share on other sites More sharing options...
Genx Posted November 17, 2006 Share Posted November 17, 2006 Take a look at this thread: http://www.fmforums.com/forum/showtopic.php?tid/179030/post/216003/hl// However just use your client ID as the value you are comparing. Link to comment Share on other sites More sharing options...
Genx Posted November 17, 2006 Share Posted November 17, 2006 Just as a side note, before ever executing a script that involves deleting a large portion of your data... make sure you have a backup of the file. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6367 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 accountSign in
Already have an account? Sign in here.
Sign In Now