Hi all.
I have two tables. One table has a basic list of items (Apples, Pears, Bananas, Oranges, etc). Lets call this tblFruit. This table looks like this.
ID | Fruit Name
The other table contain records of customer selections. A customer can select many different types of fruit. Lets call this tblPurchases. Table purchase looks like this
ID | Customer ID | Fruit Bought
I need a query that tells me what selections the customer hasn't made. The condition is that I can select any customer I want so that it would probably require the Customer ID
I tried using the unmatched wizard but didn't work. it keeps on showing me selections the customer did make, which is the complete opposite of what I need.
The reason I need this is so that I can make a combo box that shows choices left to make and does not display choices already made.
Any help appreciated.
Cheers
Bookmarks