Finding duplicate records from two files.

[Rangoon]

I have two files [Contacts] and [New Data]. Both files contain the same basic information and are both FM 5.5 files.

What I want to do is import the information from the [New Data] file into the [Contacts] file and delete the duplications by Phone Number.

Thanks for your help...

[BobWeaver]

First make copies of both files, and then work with the copies.

Next, do an import in the reverse direction from Contacts into New Data, using the update existing records option. Use the phone number as the match field in each file, (the symbol between each field will be <=>, not =>), and don't select any other fields for import. What this does is find the set of records in the New Data file that are duplicates of records in the Contacts file. Now, do a "Show Omitted" which reverses the found set to the non-duplicates.

Finally, you can import the non-duplicates into the Contacts file, because only the current found set in New Data will import.

[Rangoon]

Bob,

Thanks for getting back to me. I