Creating Primary Keys in Access

[robbuonocore]

I have a situation where I want to create the Primary Key for a table.
I want the primary key to be a combination of the current user and an
autoID number. Can anyone tell me how to do this at the table level?

Robby

 

[G. Vaught]

Hightlight them both at the same time and then set the key while you are in
the design mode of the table.

 

[Roger Carlson]

Just a question. What advantage does this give you over just having the
Autonumber field as the Primary Key?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L