Hello guys,
I'm trying to build advanced search page with a keyword textfield and a drop down menu to select from search by Category, Supplier or Trade Name very similar to the one here - www.caterer.com/products

I've got 3 tables - Suppliers(S), Products(P) and Categories(C) where in 'S' I've got SupID and all details, in 'C' CatID, CatName and Description and in 'P' ProdID, ProdName, and CatID and SupID which are linked to 'C' and 'S' accordingly.

Can anyone point me to the right direction, please?
Thanks in advance
Tina