if there is more than one primary key 1

[Newton]

I am wondering if I use more than one primary key, how Access will handle the integrity.

If I wanted to have all records be unique based on a combination of two fields do I just make both of those fields primary keys.

ie) ProjectID + Building number (having both of them be primary keys. Does that mean I can still have 2 building 112 so long as they are not both under the asme projectID?

I want my user to be able to search based on project, then building number. There would never be two building numbers the same in a project, but I am just not sure that Access primary keys are thinking in terms of "and" instead of "or"

what do you know?

 

[Hmadyson]

I use double and sometimes triple keys all of the time, it is not a problem. Some people may suggest making autonumber keys, but I believe that multiple keys are fine.

 

[Newton]

Does it work the way I decribed though where the uniquness of a record is defined by both the keys?

project 1 building 100
project 2 buliding 100

would it allow that

 

[ananab]

It thinks in terms of AND, therefore you can have two building 112's as long as they are not in the same project. It will treat them as different.

So, yes it works the way you described.