If you use the Merge/Purge Wizard found under the 'Tools' menu you can pick any field from the contact table and use it as part of the matching criteria. The following is the list of fields and weights that I use when looking for dupes.
GM Field Method Weight
Address1 Soundex 30
City Soundex 10
Company Soundex 50
State Soundex 10
ZIP Soundex 10
Qualifying Weight: 80
I then have it create a list that I review and manually merge each one instead of letting it do the merge automatically.
Sorry. I wasn't clear in my question. They want to be able to dup check on address when creating a new contact. Right now you can only check phone, email, and name.
The Merge/Purge info was helpful though. I will keep that handy.
1 of 1 people found this helpful
That would be a nice feature. I do not know of a way to modify the duplicate check feature when adding a new contact other then perhaps creating a custom trigger. I have considered doing that in the past and decided to instead have the users be responsible for doing the check.
GM also checks Email address and if you have the option checked will not allow duplicate email addresses to be added.
We have created a procedure for the entry of new contacts to the database. The user first does a check for the company name using the Search Center. They then sort the list by CITY and look for a matching address. If they don't find one they are free to add the new contact.
An additional check could be done using the Universal Search for the Address1 information. Click on the "Advanced" button in Universal Search, uncheck "All" and check only "Contacts"