Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Run the Query Wizard in Access 2013
How to Start the Report Wizard in Access 2013
How to Create a Navigation Form in Access 2013

10 Things You Need to Know about Relationships in Access 2013

Relate the primary key field in the parent table with that same field (not the primary key) in the child table.

This is the most common scenario. The parent table contains a primary key field and the child table contains the same field name. For example, a Customers and Orders table might share a CustomerID. CustomerID is normally the primary key of Customers and a foreign key in Orders.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Set Table Relationships in Access 2013
How to Import Data Sources in Access 2013
Changing Form Controls with VBA in Access 2013
Access 2013 All-In-One For Dummies Cheat Sheet
How to Create a Form that Appears When Access 2013 Opens
Advertisement