If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple field indexes: first and last name in a unique entity
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? |
#2
|
|||
|
|||
Multiple field indexes: first and last name in a unique entity
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? -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Brigid Kowalczyk" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|