Adding Parent Table Columns to a Key

You can add additional columns from the parent table to a primary key or an alternate key.

1. Open the key's property sheet and click the Columns tab.
2. 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).
3. Select one or more columns and click OK in each of the dialog boxes.