MAILERS+4:FAQ:Duplicate Check

Key Field” Option

What is the “Key Field” option when checking for duplicates?

Any field in your list can be formatted as a key field and Duplicate Check will use it to find exact matches. Typical uses for the Key Field are customer number, reference number or even a company name. If you format the company field as your key field, Duplicate Check will tag duplicate records by finding records with company fields that exactly match your key field.

Keep Record Lowest, Highest Option

What is the “Keep Record Lowest, Highest option?

Lowest

Among a set of duplicate records, Duplicate Check will keep the record with the lowest record number and tag the rest as duplicates.

Highest

Among a set of duplicate records, Duplicate Check will keep the record with the highest record number and tag the rest as duplicates.

Number of Lists Run at Once

How many lists can I check for duplicates at one time?

With the Multiple Lists function it is possible to compare up to 15 lists at one time when checking for duplicates. Any duplicate records shared among lists can then be marked for deletion and removed using the Pack feature under the Database menu.

Removing Duplicates

After running Duplicate Check how do I remove the duplicates from my list?

When at the Duplicate Check options screen you will see an option of "Mark Duplicates for Deletion". Duplicate Check will automatically mark for deletion all dBase records it tags as duplicates. After the Duplicate Check is done go to the Pack feature under the Database menu and click on the Pack command.