Index, no duplicates, using three fields? 1

[gusbrunston]

[tt]
Hi:

I need to prevent two (or more) users entering the same Client from a form into the Clients' table.

The ClientID field (no duplicates) doesn't help because the duplicate records just have an incrementing PK.

I'd like to index a combination of FirstName, MiddleInitial, and LastName. I know that's not perfect, but it's better than what I've got.

i.e., will this work?

------------------
FirstName |
MiddleInitial |> one index, no duplicates
LastName |
------------------

or?

Appreciate your suggestions. [tt] Gus Brunston - Access2000[/tt] Intermediate skills.

 

[PWise]

should work as long names are spelled the same way
look in to useing tel# as unique id

 

[gusbrunston]

[tt]
Ah! Telephone number! Thanks very much. [tt] Gus Brunston - Access2000[/tt] Intermediate skills.