|
Forms and
Subform Design, part 1 defined the scope of the programming: we
wanted to search the movies by Rating. This is a one-to-many
relationship. Microsoft Access represents a one-to-many relationship
with a Form and Subform. The Movie Search Form stores the Rating in a new table, tblMovieSearch. The Movie Search Subform
lists the movies that match that criteria. It looks up the movies with a
Select Query based on the movies Table: tblMovies. Forms and
Subform Design, part 2 links the Form and Subform by a common
Field: Rating. This lesson walks through the steps and offers some
options for troubleshooting the programming. Let's get started.
Access 2010: Example of the completed Form and Subform |
|
| |
