null in one table does not allow display of a field in another table

[adhhealth]

We use crystal version 8.5. I have 3 tables linked(Item field).
In visual linking expert we see it as m1-m2-m3.(item field in all the 3 tables).
I have m2.lotno. ,m3.binno. on the report.
considering an item for a lot no. it displays corresponding binno.
For some items m2.lotno. is null but it has some value in m3.binno.

but it does not display m3.bino.(as there is a null value in m2) But for those items I want to display binno. too. Is there a way?

 

[synapsevampire]

It sounds like you might join the Item Field in M1 to M3, not through M2 to M3.

You also might want to alter the links to be Left Outer joins, hard to say though from thsi much info.

-k

 

[adhhealth]

I need to have link between m1-m2-m3 because there are so many other fields on the report which need this linking..where do we change the links as the left outer joins?

 

[synapsevampire]

If M1 goes to M2, and there isn't a match in M2, then logically there will not be a match from M2 to M3 because there isn't an M2.

A Left Outer won't change this fact.

You might want to spend some time reading up on joining tables, this isn't a Crystal issue, this is how databases work.

To change to a Left Outer right click the link in the Database->Visual Linking Expert and select Options->Left Outer.

-k