Go to the Visual Linking window. Left click on the link between those fields
and select Options. Select Left Outer Join. This will give you all the values
in the table on the left whether they match the table on the right or not. In
your report you need only print the ones where the value in the second table is
null.
Quote:
>Subject: comparing two tables
>Date: 4/7/02 6:20 PM Central Daylight Time
>I need to compare a field in two different tables, both tables have
>the same field but I need to return the values that is in one table
>but not in the other, using Crystal Reports. I can get the report to
>return the values when the values are in both tables. But not when one
>table has different values. I need to return all values in one table
>that isn't in the other.
>Thanks
comparing two tables