Creating Relationships in Microsoft Access 2010

By Mike Chapple, About.com Guide

Finally, review the completed relationships diagram to ensure that it correctly depicts your desired relationship. You can see an example in the image above.

Notice that the relationship line joins the two tables and its position indicates the attributes involved in the foreign key relationship.

You'll also notice that the Routes table has a 1 at the join point while the Runs table has an infinity symbol. This indicates that there is a one-to-many relationship between Routes and Runs. For information on this and other types of relationships, read our Introduction to Relationships. You also may wish to review the following definitions from our Databases Glossary:

• Relationship
• One-to-One Relationship
• One-to-Many Relationship
• Many-to-Many Relationship

Congratulations! You've successfully created a relationship between two Access tables.

Previous

• Getting Started
• Start the Relationships Tool
• Add the Related Tables
• View the Relationship Diagram
• Create the Relationship Between the Tables
• View the Completed Relationships Diagram

Next