Forename+Surname Field, stopping duplication

[Barryonepointfour]

Hey I'm totally stuck on how to do this across two fields. I know with one you can just change the Indexed to no duplication but I need there to be duplication across each field, but no duplication when combined. :banghead:

I have three fields CastID, Forename, Surname. Only Forename and Surname are visible on the form. I need to be able to add new Cast members, but I don't want to be able to add them if they already exist.

For example I have Tom Hanks in the database already, I want to be able to show an error if someone tried to add another Tom Hanks, but if someone added Tom Cruise or Brian Hanks no error.

Sorry if that was badly explained, fairly new to access.

 

[jdraw]

Google composite unique index

 

[bob fitz]

Is there no chance, what-so-ever, that you may one day need to add a second, but different "John Doe", John Smith, Bob Fitz".

 

[Barryonepointfour]

Nope thanks, since the information is about actors the chances are incredibly low and being a non-profit database used just by one person he accepted if there were two actors of the same name he would have Tom Cruise and Tom Cruise1. The Composite Unique Index has solved my problem.