Click the right side of the Data Type text box for the CustomerID field to display the list of data types, and then click Lookup Wizard. A message box appears, warning you to delete the relationship between the tblCustomer and tblContract tables if you want to make the CustomerID field a lookup field. See Figure 5-31.
FIGURE CANT COPY.
Access will use the lookup field to form the one-to-many relationship between the tblCustomer and tblContract tables, so you don't need the relationship you previously defined between the two tables.