Don just received a request from Paul to develop a database for a new pharmacy that Paul is opening.

Don just received a request from Paul to develop a database
for a new pharmacy that Paul is opening in Edmonton, Alberta, Canada. Because
the data collected about customers, employees, and drugs is slightly different
in Canada, Don decides to create the databases simultaneously, but separately,
so he can account for the individual differences in each version. Don wants you
to create the database for Hudson Bay Pharmacy. (You will create nine tables in
this exercise using the skills you have learned so far. You will create three more
tables in the Level 2 Steps To Success exercises.) He will
»

Don just received a request from Paul to develop a database
for a new pharmacy that Paul is opening in Edmonton, Alberta, Canada. Because
the data collected about customers, employees, and drugs is slightly different
in Canada, Don decides to create the databases simultaneously, but separately,
so he can account for the individual differences in each version. Don wants you
to create the database for Hudson Bay Pharmacy. (You will create nine tables in
this exercise using the skills you have learned so far. You will create three more
tables in the Level 2 Steps To Success exercises.) He will provide you
additional information so you know how to account for the differences in the
Canadian version of the database.

Complete the following:

Change the PlanID field in tblCustomer to a lookup field
that displays the PlanID and PlanName values from tblHealthPlan but stores only
the PlanID values. Sort values in ascending order by PlanID and adjust the
lookup column widths as necessary to display the values that will be stored in
these fields.

TROUBLESHOOTING: In order to complete this task, you need to
think about the record(s) that might already be entered in the table and decide
whether it is okay to change the data integrity. Typically, you would want the
data integrity to be updated. After you create a lookup field with the Lookup
Wizard, a dialog box might appear letting you know that data integrity rules
have been changed. Click the OK button.

»