|
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.
|
|
| |
