Create a relationship between tables (ADP)

Microsoft Office Access 2003

  1. In the Database window, click Database Diagrams Button image under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
  2. In your database diagram, click the row selector Row selector for the database column or combination of columns that you want to relate to a column in another table.
  3. While the pointer is positioned over the row selector, click and drag to the related table.
  4. Release the mouse button. The Create Relationship dialog box appears and attempts to match the columns you selected with columns of the same name and data type in the related table.
  5. In the Create Relationship dialog box, confirm that the columns you want to relate are shown in the Primary key table and Foreign key table lists.
  6. Choose OK to create the relationship.

On the diagram, the primary key side of the relationship is denoted by a key Key symbol symbol. In one-to-one relationships, the table that initiated the relationship determines the primary key side. For example, if you create a relationship from the pub_id column in the publishers table to the pub_id column in the pub_info table, then the publishers table is on the primary key side of the relationship.

ShowCreate a relationship in Table Designer

  1. Click Tables Button image under Objects, click the table that is on the foreign key side of the relationship, and then click Design on the Database window toolbar.
  2. Right-click in the Table Designer and choose Relationships.
  3. Click the New button.
  4. From the drop-down list in Primary key table, choose the table that will be on the primary-key side of the relationship. In the grid beneath, enter the columns contributing to the table’s primary key. In the adjacent grid cell to the left of each column, enter the corresponding foreign-key column of the foreign-key table.
    The table designer suggests a name for the relationship. To change this name, edit the contents of the Relationship name text box.
  5. Choose Close to create the relationship.