Copying Column Properties to a Foreign Key Column
When you copy a column from one table to another table, the column name and many of the other properties you defined for that column in the original table are copied to the new location. You can copy column properties from a primary key column to a foreign key column if you want to relate the two columns. Related columns must have the same data type (or data types that can be related) and length property settings.
To copy primary key column properties to foreign key columns
In your database diagram, select the primary key columns that you want to copy. Primary key columns are indicated by a key symbol .gif)
in their row selector.
Copy the columns to the foreign key table. For details, see Copying Columns from One Table to Another.
Drag a relationship line from the columns in the primary key table to the same columns in the foreign key table. For details, see Creating a Relationship Between Tables.