Selecting a month from a list of names is convenient for people, but if your computer has to deal with this information in some mathematical way, a list of the numbers associated with each month is easier for it to use.
In this exercise, you will use the Lookup wizard to create a two-column list of months from which the user can choose.
USE the MulticolumnLookup database. This practice file is located in the Documents\Microsoft Press\2007OfficeSBS\AccessKeeping folder.
OPEN the MulticolumnLookup database. Then display the Field Property Test table in Design view.
Add a new field below Month1. Name it Month2, and set the data type to Lookup Wizard.
Click I will type in the values that I want, and then click