Ok so I added 3 product drop downs. ArtWork, Photography and Product Types. I renamed the record sets, every thing works I get 3 matching menus. I open the first recordset and I have the following:
SELECT CategoryName, CategoryID
WHERE productcategories.CategoryID=4 OR productcategories.CategoryID=1
when I view the page only Category 1 shows up in the menu. What am I doing wrong?