Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
10 Things You Need to Know about Relationships in Access 2013
How to Run the Query Wizard in Access 2013
How to Import Data Sources in Access 2013

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

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Start the Report Wizard in Access 2013
How to Create a Navigation Form in Access 2013
Finding Alternatives to Access Data Projects
How to Filter Multiple Fields in Access 2013
Getting Help with Functions in Access 2013
Advertisement

Inside Dummies.com