How to Set Table Relationships in Access 2013

For each pair of tables you want in the relationship, click the table and then click Add.

In the big Relationships workspace, a little window lists the fields in the selected table. As you add tables to the layout, a separate window appears for each table. You can see these windows to the left of the Show Table dialog box.

Repeat Step 2 for each pair of tables you want to relate. If one of the tables in the pair is already present (due to an existing relationship it has with another table), you don’t have to add it again.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus