Steve

You don't mention how many persons' names you have, but is it inconceivable
that your database could have more than one "John Q. Public"?

I'd be very leery of trying to create a unique index on that combination.

.... but yes, you can use multiple fields (no need to "combine" them) as an
index.

It sounds like Access is telling you that you ALREADY have duplicates!

Good luck

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Steve Stad" wrote in message
...
I have 3 fields for Name. LastNm, FirstNm, and Middle Initial. How do I
ensure the full name, i.e., "LastNm, FirstNm, MiddleInitial" combined are
unique and not duplicated in the table? I thought I could index but not
sure
where/what to check for 'Unique' (e.g., on all three fields?) or if I need
to
use a primary key. I got a msg saying 'changes were not successful
because
the create duplicate values in index, primary key, or relationship.'