graphic2
graphic1

Sample of a Form with a Combo Box Control

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.