Microsoft Office Tutorials and References
In Depth Information
Referential Integrity
AC 187
3
Click the Recruiter table and then
click the Add button to add the
Recruiter table.
Click the Client table and then
click the Add button to add the
Client table.
Recruiter
Number fi eld in
Recruiter table
Click the Close button in the Show
Table dialog box to close the
dialog box.
Resize the fi eld lists that appear so
all fi elds are visible (Figure 3–69).
Do I need to resize the fi eld lists?
No. You can use the scroll bars.
Before completing the next step,
however, you would need to
make sure the Recruiter Number
fi elds in both tables appear on
the screen.
Recruiter Number
fi eld in Client table
fi elds in
Recruiter table
fi elds in
Client table
4
Drag the Recruiter Number fi eld
in the Recruiter table fi eld list to
the Recruiter Number fi eld in the
Client table fi eld list to open the
Edit Relationships dialog box to
create a relationship.
Do I actually move the fi eld
from the Recruiter table to the
Client table?
No. The mouse pointer will
change shape to indicate you are
in the process of dragging, but the
fi eld does not move.
Figure 3–69
Click the Enforce Referential Integrity check box.
Search JabSto ::




Custom Search