Composite Keys

Multi-Field Keys

 To quickly create a multi-field primary key, while in the table's Design View: Hold the Ctrl key and click each field that you want to make up the primary key. Choose Edit>Primary Key from the menu bar, or click the Primary Key button on the toolbar.

 Access creates the composite primary key for you.



See all Topics