Forum Discussion
Solved
If/Else For 2 Tables
First, I have to say, this user community is AWESOME! Everyone is so professional in the way they handle questions and responses that I do not see in other user groups. Now, I have a report I am ...
if the relationship between warehouse table and location table is many to one
you can try this
Column = if( RELATED(PalletLocation[LOC_TAG])="","Include",RELATED(PalletLocation[PALLET_LOC]))pls see the attachment below
Based on the sample data, if qryWarehousePallet.PALLET_LOC is in tblPalletLocation.PALLET_LOC, then it returns tblPalletLocation.LOC_TAG, which would be Exclude, else it returns the word Include.
if the relationship between warehouse table and location table is many to one
you can try this
Column = if( RELATED(PalletLocation[LOC_TAG])="","Include",RELATED(PalletLocation[PALLET_LOC]))pls see the attachment below
Thanks ryan_mayu that worked perfectly.
you are welcome