Microsoft Office Tutorials and References
In Depth Information
2
Click the Client table in the Show
Table dialog box.
Click the Add button to add a fi eld
list for the Client table.
Close the Show Table dialog box
by clicking the Close button.
join line
Expand the size of the fi eld lists so
all the fi 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 fi elds are exactly the
same, the data types are the same,
and the matching fi 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 fi elds and dragging
to the other matching fi eld.
fi eld lists
resized
Figure 2–47
3
In the design grid, include the
Recruiter Number, Last Name,
and First Name fi elds from the
Recruiter table as well as the Client
Number and Client Name fi elds
from the Client table.
View
button
Select Ascending as the sort order
for both the Recruiter Number
fi eld and the Client Number fi eld
(Figure 2–48).
Recruiter Number, Last
Name, and First Name
fi elds from Recruiter
table included
Client Number and Client
Name fi elds from Client
table included
Ascending
sort order
Figure 2–48
Search JabSto ::




Custom Search