I have three tables: tblProducts,tblOrders,and tblTempCart.
Process:
When a product is chosen, it is added to the tblTempCart table based on the OrderID then the customer is returned to the products page.
Problem:
I want to write a query that gets all the products from the tblProducts table that are NOT listed in the tblTempCart table. I have tried everything but can't seem to find out how to do it. Each product is unique so customers must be prevented from buying the same product twice. After adding a product to their cart and return to shopping, I don't want that same product to be listed on a products page. The relationships are as follows and the three tables are related this way:
tblProducts.ProductsID->
tblTempCart.intTCProductsID
tblTempCart.intTCOrdersID->
tblOrders.OrdersID
I have used query designer for years and has always served my purpose until now. Any help or link to proper resources would be helpful. Thanks.
John Moritz
Process:
When a product is chosen, it is added to the tblTempCart table based on the OrderID then the customer is returned to the products page.
Problem:
I want to write a query that gets all the products from the tblProducts table that are NOT listed in the tblTempCart table. I have tried everything but can't seem to find out how to do it. Each product is unique so customers must be prevented from buying the same product twice. After adding a product to their cart and return to shopping, I don't want that same product to be listed on a products page. The relationships are as follows and the three tables are related this way:
tblProducts.ProductsID->
tblTempCart.intTCProductsID
tblTempCart.intTCOrdersID->
tblOrders.OrdersID
I have used query designer for years and has always served my purpose until now. Any help or link to proper resources would be helpful. Thanks.
John Moritz