Is there an automated way to delete all records where one field within a record is the same as another.

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

Thanks lee I was searching under dedupliacte and deduplicating