Access does not allow Primary key with two fields

[Reckon]

I have a table with a student id and course id. The People table has a record for each individual. A record in the orders table will have multiple "People" in it (e.g., Person Placing the Order, Technical Contact, Budget Officer, etc.).Then I have a composed key. But this is not normal.

[Billie]

You will need to Open the table in design view, then you need to pulled the records from the selectors there you would get square blocks where on the left column name of the 2 columns you want as PKs, or, then hold the Ctrl & click the record selectors of the columns you want as PKs. use an Autonumber as your primary key. If there are other fields that need to be unique, I create a unique index on them. Then On the main window on the main menu click Edit > Primary Key. Once this has finished Close & Save the table. If there is duplicate data in the PK columns you will not be able to save the new table design.

[Janhavi4U]

when you are in the relationship window, drag the relationship from People to the first field, check Referential Integrity (RI) store the customer's address in each record in the Orders table, you store that information once in a record in the Customers table.In general you could have guessed this answer if you imagined that columns not indexed separately, but indexed concatenation of columns (it's not completely true, but it works for first approximation).