Using a relational database like Access can sometimes be confusing when you need to enter data into more than one
table and when you want to know which of those values correspond to an entry in a lookup table.
An example of a lookup table is a table of consultant types, as shown below. Here are the entries for the consultant
types available in the lookup table called ConsultingTypes:
The field called ConsultingTypeID will be the one mapped to the entry in the main table used, Consultants.
You can specify that you want to use a lookup table for a field entry by picking the Lookup Wizard for the Data Type property of the field.
The Data Type property of a field tells Access what kind of information is going to be typed into the field: strings, numbers, and so on.
There will be more on data types later in this module.
Access lets you set up descriptive values that display onscreen when you enter data for the two different tables. The graphic below shows how
two tables would have to be opened to see which legitimate values could be entered into a field that refers to another table.
Creating Lookup Field
In the next lesson, you will learn how to use the correct data type for optimal performance.