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.