go to Database Menu at teh top of Crystal
select DB Expert
click on the LINKS tab
You will see your tables and lines drawn beteen them.
THis is the diagram of how your tables are joined (and on what fields)
double click on the line joining your PHONE and CONTACTS tables
A box opens
on the lef tis ajoin type
at the top of the link options it describes the join
if CONTACTS is listed first use a left outer join
if PHONES is listed first use a RIGHT outer join
Yo can also "enforce" in here but it is redundant to enforcing when you use the fields in the report itself.
Link type should remain as "="
Go back into your report and test it out.
If you are still missing data reverse the join type ...if you picked LEFT swithc to right, etc.
IP Logged
