Use the Combo Box

Before You Begin: Change the View
Go to Form Design Tools ->Design->Views.
Choose a View: Form View.

5. Try it: Test the Combo Box Control
The Movie Form is open in Form View.
Select a Rating: R

What Do You See? Do you see one Column or two? When you select a value from the list does the Combo store the Text or a Number?

 

Summary

The Movie Form uses a Combo Box now to look up a value in the Rating Table and store that value in the Movie Table.

 

This is an example of one-from-many.

Each movie has only one Rating. The Combo Box lets the User select one Rating from a Table that has many Ratings, tblRating.

 

That was a good start. Go get a cookie and meet me for the next lesson.