I have two tables linked by two fields, therefore making a synthetic table. One of these tables is a product table the other is a sales table. The tables are linked by product ID and grouping code. All sales either have a grouping code, a product ID, or both. The product table has a field called product category ( every product has a category and grouping code). When I restrict the data to a certain product category, I am only seeing sales with a product IDs and grouping codes in that category. The selection is eliminating sales with a product Id and without a grouping code and vise versa. Is there a way to set this up so when I select a product category , I can see sales with product IDs or grouping codes ?
