Relationships Explained
One-to-Many Relationships
One of the strengths of Access is the ability to create relationships between tables. As an example of a relationship, consider the Customers and Orders tables from the Northwind sample database.
In the Northwind business case, every order comes from a single customer. Of course, a customer can place more than one order, which means that the Customers and Orders tables are in a one-to-many relationship with the Customers table on the "one" side and the Orders table on the "many" side.
Many-to-Many Relationships
It is also possible for two tables to be in a many-to-many relationship, where multiple records ...
Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.