Hello pradosh and Happy New Year! Let the 2018 be more fruitful and prosperiuos one!
Thank you for your suggestion. It works flawlessly, but I missed the fact, that dealing with hundreds of products it's pretty hard to see what you're looking for. So, in order to be more useful, the data should be organized in groups.
I've tried to do it, but I failed. So, please have a look at it.
Here are the tables with the new fields added (in bold)
Table 1: PRODUCT_LIST
Table 2: SALES
After selecting a Client, I'd like to select a ProductGroup and TypeOfProduct and then it's pretty clear what the Client doesn't buy.
I hope, I have described it clear enough.
Thank you in advance!
No, I don't need your help for creating two more fields. I failed to describe what I'm trying to do.
These two fields exists in the table already. I use'em to reduce the number of shown products, using these two category fields - ProductGroup and TypeOfProduct.
Let's imagine that the table holds some automotive data as follows:
ProductID / ProductName / ProductGroup / TypeOfProduct
01 / Volvo / cars / sport wagon
02 / Volvo / truck / heavy truck
03/ Audi / cars / sport wagon
04 / Audi / cars / SUV
... and so on.
What I'm trying to do, but I can't, is to see which products haven't been bought by the selected Client, but in order to reduces to number of shown products, I need to filter the results using the other 2 category fileds, as well.
Let's assume that a client ABC has bought the car #04 - Audi / cars / SUV.
I'd like to see what else he can buy, but not all the other references. Just those that are made by Audi (ProductName) and are not trucks i.e. cars (ProductGroup). Or all the cars (ProductGroup) which are sport wagon (TypeOfProduct).