One-From-Many
Relationships:
The Rating Combo Box
Use a
Table to Add Data to Another Table
This
lesson will add a Combo Box to the Movie Form. The Combo Box will
select data from the Rating Table and add the Rating to the Movie
Table.
What Are
the Steps?
Create a Rating Table and add the Rating data.
Add a Rating Combo Box to the Movie Form.
Troubleshoot the Combo Box Properties.
What Are
the Issues? The Combo Box Wizard does NOT
always choose the Field that matches. This lesson shows one method
for selecting the Field that matches.
What is
the Key Concept? The focus of this lesson
is on the data. Each Field in a Table has a specific data type:
Number, Text, Date, etc.
When you
add data from one Table to another the data has to be the same type.
Text goes with Text. Numbers go with Numbers.