This paper describes how to create a lookup table by creating a data entry form for the Orders table in the Northwind database. Instead of displaying the CustomerID field, a combo box will be used to display the CompanyName from the Customers table that corresponds to the correct CustomerID in the Orders table.
|