harrrrrrry Posted March 31, 2004 Share Posted March 31, 2004 Is there an automated way to delete all records where one field within a record is the same as another. Link to comment Share on other sites More sharing options...
Lee Smith Posted March 31, 2004 Share Posted March 31, 2004 Hi Harry, This subject comes up from time to time, so a search for Duplicate, Duplicate Records, etc. would probably turn up a wealth of information. Here are four FileMaker Technical Articles that may be of help to you: http://www.filemaker.com/ti/106228.html http://www.filemaker.com/ti/103852.html http://www.filemaker.com/ti/104753.html http://www.filemaker.com/ti/104377.html Also, take a look at the File "Calculations and Scripts.fp5" that came with FileMaker, there is a script called "Finding Duplicate Records" that can be helpful. Also CobaltSky (AKA Ray J. Cologon), has a site with many excellent example files, check out "Finding only one of each record when there are duplicates!" his URL is: http://www.nightwing.com.au/FileMaker/ AND here are a couple of other files that may be helpful. Counting Duplicates Via Aggregate Functions By: Dwayne Wright URL: http://www.afilemakeraffliction.com Deleting Duplicates - 4 methods By: John Mark Osborne URL: http://www.databasepros.com HTH Lee FileMaker Version: v6.x Platform: Mac OS 9 Link to comment Share on other sites More sharing options...
harrrrrrry Posted March 31, 2004 Author Share Posted March 31, 2004 Thanks lee I was searching under dedupliacte and deduplicating Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7325 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