how can i do it? thanks!
Printable View
how can i do it? thanks!
You can't.... There only can be one primary key in a table just like only one team can win the championship.
you can however let acces index another field and not allow duplicates.
so you can use this field as a unique identifier as well.
You can't have more than one primary key, but that key can be multiple fields. In the table designer, select all and only the fields you need and click the primary key icon.
More than one primary key would be an oxymoron.
In the Design view of your table. Select which field you want to be primary key and select the primary key button. On your next field in the field properties it says Indexed. Change thet from No to yes with no dup's. That acts likea primary key becouse it does not allow duips in the field you selected.