Microsoft Office Tutorials and References
In Depth Information
AC 186
Access Chapter 3 Maintaining a Database
To Specify Referential Integrity
The following steps use the Relationships command to specify referential integrity by specifying a relationship
between the Recruiter and Client tables. The steps also ensure that update will cascade, but that delete will not.
1
Click Database Tools on the Ribbon
to display the Database Tools tab
(Figure 3–67).
Database
Tools tab
Relationships
button
Figure 3–67
2
Click the
Relationships button
on the Database
Tools tab to open the
Relationships
window and display the
Show Table dialog
box (Figure 3–68).
Show Table
dialog box
Tables tab
selected
Relationships
window
Client table
Recruiter
table
Close button
Add button
Figure 3–68
Search JabSto ::




Custom Search