PHV you rock, I selectivly read your reply. Upon re-reading your post and applying the changes it works great. Once again thank you very much for your help!
Gratefully,
Patrick
Acutally the CategoryIDs are numbers so I didnt use them, I just posted them as A & B for ease of viewing(my mistake). I just tossed the tick marks on for kicks and it didnt work. So I am still stuck, but thank you for the quick response!
I am having trouble with the following query.
Important Tables:
Product (table of products)
--ProductID
--ProductName
ProductCategories (Associates a Product with one or more categories)
--ProductID
--CategoryID
Category (table of categories that a product may fall under)
--CategoryID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.