Ex.
I want to create report that will list all active items that are not in a Zone (ABC). I need to link both Item and Bin Contents table. I can't just filter out the Zone from the Bin Content table because I want my report to exclude the item if the item exist in the Bin Content table and has that Zone.
Bin Content table ex.
Item No.| Zone
Item123 | ABC
Item123 | DEF
If I just Filter out Zone(ABC) on the Bin Content table. Item123 will still show on my report because this item also exist in Zone DEF. For this report, I wouldn't want Item123 to show up at all because the item exist in Zone ABC.
