You can add additional columns from the parent table to a primary key or an alternate key.
-
Open the key's property sheet and click the Columns tab.
-
Click the Add Columns tool to open a selection box listing all the columns in the table (except those already attached to the primary key).
-
Select one or more columns and click OK in each of the dialog boxes.