One-to-Many Relationships
The
Beginning Guide to Microsoft Access 2010 demonstrated one-to-one
relationships. There was one Table, tblMovies, for the Movie
Form. There was another table, tblCustomers, for the Customer Form. Each
Query had only one Table as well. This is a simplified approach to
programming that introduced the database objects: Table, Query, Form and
Report.
In real life,
most transactions are one-to-many relationships. For example, one
customer may rent many movies. There are several ways to create a
one-to-many relationship in Microsoft Access. The Intermediate
Guide to Microsoft Access 2010 will demonstrate how to create Forms
as well as Reports that show one-to-many relationships.