Primary Key with Two Fields 1

[kellyputty]

I have a table with only two fields. By combining those fields I will have a unique primary key for the table w/o adding another field to create a primary key. However, I don't know how to do this in MS Access.

Do you?
KellyPutty

 

[PHV]

In table design view select the 2 fields and click the PrimaryKey icon.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886