No Duplications?

[Keith Burgess]

Can anyone advise me on the following please.
I have built a very straightforward contact name and address DB to record all enquiries coming in to my business.
I don't want to enter any duplicates and I thought the best field to allow no duplications on was Address 1. Unfortunately this didn't work because I have three addresses all starting "The Old Coach House" but they are all in different locations. Then I thought of Post Codes, but we have enquiries coming in from countries that don't use Post Codes, like Ireland, so these are blank creating duplicates.
Has anyone got an answer to the problem, it's probably dead easy when you know how but being new to Access I can't see it.....HELP

Keith

 

[neileg]

Perhaps a multi field index set to no duplicates is what you want. Say the first name, last name, and the first two lines of the address. Even this won't be 100% secure because spelling or punctuation differences will make near duplicates still possible ( e.g. Bill Smith and William Smith, The Old Coach House and The Olde Coache House)

 

[Keith Burgess]

Perhaps a multi field index set to no duplicates is what you want. Say the first name, last name, and the first two lines of the address. Even this won't be 100% secure because spelling or punctuation differences will make near duplicates still possible ( e.g. Bill Smith and William Smith, The Old Coach House and The Olde Coache House)

Hi Neil,
This works like a charm, in fact it stopped me entering a duplicate this morning. Many thanks for your prompt and eficient help.
Best regards
Keith