Create a foreign key relationship with the Connector tool

  1. Open your database model diagram.

  2. Click the Connector tool on the Standard toolbar.

  3. Position the Connector tool over the center of the parent table so that the table is outlined, and drag it to the center of the child table. When the outline appears on the child table, release the mouse button.

    Both connection points appear red, and any primary keys in the parent table are added as foreign keys to the child table.

  4. Define the relationship by editing its properties.

    1. To open the Database Properties window, double-click the relationship whose properties you want to edit.

    2. In the Database Properties window, click the category that contains the information that you want to edit, and then make your changes.

      The database model diagram is updated.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.