A very unique Access query Issue : Suppose there are two tables - customer and product. Also available is customerproduct (linked table containing customers and the products they bought).i want to design a query which will list products NOT bought by a customer i.e. each customer will be listed with products not bought by him.

**Example**

**Customers**
Tom
Jim
Harry

**Product**
Shampoo
Brush
Shoe
Box

**Customerproduct**
Jim box
Jim brush
Tom brush
Harry shampoo

So, my query should display:
Jim shampoo
Jim shoe
Tom shampoo
Tom shoe
Tom box
...

I need to use lookup to get my customers and products. Making a separate table CustomersandProducts table and feeding it in manually is not an option.
Surely, there must be a way to get the results using NOT EXISTS, NOT IN, etc?
