Left join to the third table. This will get you all of the data from tables 1 and 2, regardless of whether there is data in table 3.
To determine whether a record exists in table 3, you can use something like:
not IsNull({table3.KeyField})
This will return True if there is data in table 3 and False if there is not.
If you need to have additional criteria on table 3, you'll need to edit the formula in the Select Expert and do something like this:
and
(IsNull({table3.keyfield}) or
(condition 1 and condition2...))
Note the parentheses - because of the "or" the placement is important for getting the correct data.
-Dell
IP Logged
