Tricky Formula (at least for me)

[byrne1]

I have three tables that I'm pulling data from: ITEM, ITEMLOC, ITEMLOC2. I want to pull all items from the ITEM table that have QTYONHAND>0 in either the ITEMLOC or ITEMLOC2 table.

So far I have the following record selection criteria (that does not work):

ITEMLOC.QTYONHAND>0 OR ITEMLOC2.QTYONHAND>0

This formula seems to only pull items that have ITEMLOC2.QTYONHAND>0 and I do not know why. The tables have links as follows:

ITEM.ITEMNUM=ITEMLOC.ITEMNUM
ITEM.ITEMNUM=ITEMLOC2.ITEMNUM

I am using CR v10.

 

[synapsevampire]

Change the joins to left outer.

-k

 

[byrne1]

That did the trick! Thanks for the reminder!