Anticipating the User's Tasks

Search

Building a database means thinking like a user. As you test the forms and queries, you may find yourself demanding that the database provide better information faster. Who wrote this stupid software? Hmmmm, I did...

 

Databases need multiple Search criteria. Suppose you wanted to search all of the departments, and then look up the programs each department offers. When you find the right program in the list, you should be able to click on it to read more details.

 

And Research

There are two goals here:

1. Synchronize the Combo boxes.

2. Add a Double Click Event to open the right record from the list.

 

So far, in the preceding lesson you created a Search form that filtered your list by Genre. You need to create a new Rating combo that looks up the Genre from the Search form.

 

The second query and combo box synchronize with the first. For example, suppose you choose Horror movies. The Rating combo would display the Horror ratings. I doubt if you will find many G-rated Horror flicks.