Database Reference
In-Depth Information
Because Access has scrolled the list to the Campbell entry,
it is easy to select the name you want.
6
25
Click
Cox
, and press
Tab
. Then close the
Orders
table.
Let's take a look at the one-to-many relationships between the Customers and
Orders tables and between the Employees and Orders tables that make the lookup
lists possible.
26
On the
Database Tools
tab, in the
Relationships
group, click the
Relationships
button.
Access created these relationships to support the lookup fields in the Orders table.
CLEAN UP
Close the GardenCompany06 database.