A Shot in the Dark...

The investigation begins with the record sources found in the database. You need to Search the Movies by Genre and Rating. The Front Row Video database has Genre and Rating tables. How do you use these tables to search the Movie table?

 

There are the steps:

1. Create a form with a Search Combo.

The Search Form needs a Search table.

The Search Combo with have a new query.

 

2. Design a Movie form in Datasheet view.

The Movie List will need a new record source, too.

 

3. Add the Movie List as a Subform.

 

4. Link the Form and Subform by the GenreID or the RatingID.