Exclude 1 list of products from 2nd list of products
1. I have two tables, let's call them Table1 and Table2. Table1 has ProdID field and Table2 has ProdIDex field. ProdIDex contains only products I want to exclude from ProdID when I create charts etc. The logic would be:
if prodID <> ProdIDex display ProdID
2. I also would like to be able to put a "button" titled "Display ProdIDex" which I could activate and deactivate. This button would then run the above instruction and either remove or display ProdIDex products on a chart etc. Is this possible at all?