Database Reference
In-Depth Information
3
Open the
Orders
table, and drag across the
CustomerID
and
EmployeeID
field names
to select those fields. On the
Fields
tool tab, in the
Add & Delete
group, click the
Delete
button. Then click
Yes
to permanently delete the fields and
Yes
to delete their
indexes.
Now let's add a new Employee lookup field.
4
At the right end of the table, click the
Click to Add
field. On the
Fields
tool tab, in
the
Add & Delete
group, click the
More Fields
button, and then click
Lookup &
Relationship
to start the
Lookup
wizard.
5
With
I want the lookup field to get the values from another table or query
selected, click
Next
.
6
To identify the table on which the lookup field will be based, click
Table: Employees
in the list. Then click
Next
.
7
On the third page, in the
Available Fields
list, double-click
EmployeeID
, then
FirstName
, and then
LastName
to transfer those fields to the
Selected Fields
list.
Then click
Next
.
8
On the fourth page, click the arrow for the first sort box, and click
LastName
in the
list. Then click
Next
. Notice on the fifth wizard page that by default, the
EmployeeID
field (the key column) is hidden.
You can adjust the column widths to fit the values the same way you would adjust field widths.