Microsoft Access 2010 Bible

Part V: Access and Windows SharePoint Services

1162

FIGURE 35.19

Specify the field used to populate the lookup field in tblSales.

The last screen of interest in the Lookup Wizard is shown in Figure 35.20. We want to make sure

that data integrity is enforced between tblSales and tblCustomers. This means we want

Access to make sure that any value entered in the CustomerID is matched in tblCustomers.

This rule ensures that no record in tblSales is orphaned by the user entering an ID value that

doesn’t match an existing customer.

FIGURE 35.20

Make sure the Enable Data Integrity check box is selected.