Representing One-to-Many Relationships

In real life, one customer gets many movies. In Microsoft Access, a one-to-many relationship is created with a Form and a Subform. A Subform is a Form, usually in a Datasheet or List View, that is linked to the Parent Form.  These database designs will be taught in two lessons. In the first lesson we will create two new Forms: a MovieSearch Form and a MovieSearchSubform. Each Form will have a new Record Source. The previous lesson used a Combo Box to select one value from many.

 

This lesson will use a Combo Box to filter the movies: there are many movies that have the same Rating. In the following lesson, we will link the Form and Subform. We will test the programming and troubleshoot the possible errors.

 

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