Microsoft Office Tutorials and References
In Depth Information
• Click the Client table in the Show
Table dialog box.
• Click the Add button to add a ﬁ eld
list for the Client table.
• Close the Show Table dialog box
by clicking the Close button.
• Expand the size of the ﬁ eld lists so
all the ﬁ elds in the Recruiter and
Client tables appear (Figure 2–47).
I didn’t get a join line. What
should I do?
Ensure that the names of the
matching ﬁ elds are exactly the
same, the data types are the same,
and the matching ﬁ eld is the
primary key in one of the two tables.
If all of these are true and you
still don’t have a join line, you can
produce one by pointing to one of
the matching ﬁ elds and dragging
to the other matching ﬁ eld.
ﬁ eld lists
• In the design grid, include the
Recruiter Number, Last Name,
and First Name ﬁ elds from the
Recruiter table as well as the Client
Number and Client Name ﬁ elds
from the Client table.
• Select Ascending as the sort order
for both the Recruiter Number
ﬁ eld and the Client Number ﬁ eld
Recruiter Number, Last
Name, and First Name
ﬁ elds from Recruiter
Client Number and Client
Name ﬁ elds from Client