Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
Access also will reject the deletion of a recruiter for whom related clients exist.
Attempting to delete recruiter 21 from the Recruiter table, for example, would result in
the message shown in Figure 3–73.
attempting to delete
a recruiter for whom
Microsoft Ofﬁ ce
Access dialog box
Access would, however, allow the change of a recruiter number in the Recruiter
table. Then it automatically makes the corresponding change to the recruiter number for
all the recruiter’s clients. For example, if you changed the recruiter number of recruiter 21
to 12, the same 12 would appear in the recruiter number ﬁ eld for clients.
To Use a Subdatasheet
Now that the Recruiter table is related to the Client table, it is possible to view the clients of a given recruiter
when you are viewing the datasheet for the Recruiter table. The clients for the recruiter will appear below the
recruiter in a subdatasheet . The availability of such a subdatasheet is indicated by a plus sign that appears in front of
the rows in the Recruiter table. The following steps display the subdatasheet for recruiter 24.
• Open the Recruiter table and hide
the Navigation pane (Figure 3–74).
+ sign indicates
click to display
for recruiter 24