Multiple field indexes: first and last name in a unique entity

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm making a database for all the students and staff at a law school. for
those with the same last name, I want to have two fields to force uniqueness
upon, not just one. How do I do that?
 
What happens when you have two John Smith's in the school?

Open the table in design view.
Go to View, Indexes.
In the next open line put something like NamesIndex in the Index Name column.
Select your Last Name field in the Field Name dropdown.
Directly below this, select the First Name field from the dropdown.
Click back onto this index name.
Towards the lower left of the window, change Unique to Yes.

Johnny Smith?
 
Back
Top