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.

Microsoft Office Access 2010: Example of a Form with a Subform