Custom Primary Key Field

K

Kathy

how do you create a primary key field when using a social
security number or a numbering scheme of your choice???
 
R

Rick Brandt

Kathy said:
how do you create a primary key field when using a social
security number or a numbering scheme of your choice???
Click to expand...

You can make your primary key from any field or group of fields that you
want when setting up your table. The only requirement is that you pick a
field or fields that will be unique per record and never contain Null
values. You just select those fields you want and press the Primary Key
button in the toolbar and then save the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
primary key - concatenated or autonumber? 6
Trying to create a report that will list unmatched records by Ticket Primary Key 0
No Primary Key! 4
Need Suggestions to Eliminate Unplanned Table Behavior 4
Combine two field’s into a third field as a default value 2
Primary Key Generated Case To Case? 3
Primary Keys yes or no? 8

Top