I presently have it set up so only selected items display as groups from my inventory table, but when I put in a column from my orders table all the values that the company hasn't had an order for in over a year or so disappear.

 

There are other tables I'd like to link in as well, and it seems to me that there is probably an easy fix to get the item numbers I want to just display throughout with eitehr a null or 0 where there is no conjunction.

 

Can anyone help me with this? I looked through about 30 pages of the forum without seeing any similar questions.

 

 

Thank you