Basic Table Link Question

[U079310]

How do I link these tables ?

Have Mstr Table A and Detail tables B and C. Want to display data on one line when data from A if found in either B OR C. The same field from A is the link within B and C. How do I set this up ?

Right now I am only getting data to display when the a record from A exists in both B AND C.

 

[hilfy]

You need to use an Outer Join (right-click on the links between Table A and either B or C, select Options and chose "Left outer).

I'm sure there's probably another way to do this, but what I would then do is create a formula something like this:

{@PrintIt}
not IsNull({tableB.field linked to table A}) or
not IsNull({tableC.field linked to table A})

This will give you a true/false result so you include it in your record selection criteria choosing "{@PrintIt} Is True" in the select expert.

-D