Copy primary key column properties to a foreign key column (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

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.

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the primary key columns that you want to copy. Primary key columns are indicated by a key symbol in their row selector.
3. Copy the columns to the foreign key table using the Copy and Paste commands on the View menu.
4. Drag a relationship line from the columns in the primary key table to the same columns in the foreign key table. Microsoft Access shows the Create Relationship dialog box. For more information on each option, click Help.