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.
why can't programmers keep and 31 Oct and 25 dec apart. Why Rating is Useful
for every question you ask provide an answer on another thread.
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.
mutiple primary keys in ms access
Reply With Quote
why can't programmers keep and 31 Oct and 25 dec apart. 