Dataassist Search using more than two tables.
Web Developer Suite
MySql + php
Webassist e-commerce Database (new release) with modifications.
Products table has had categories ID column removed, otherwise unchanged.
Product Categories is unchanged
Product Ceremonies Added (same function as Product Categories)
ProductsToCategories Table added (Contains Product ID & Category ID)
ProductsToCeremonies Table Added (Contains Product ID & Ceremony ID)
So: I have PRODUCTS that appear in MANY CATEGORIES AND MANY CEREMONIES
Now: I've created my results page (From The Products Table) and the corresponding Details Page - They are working fine.
I've then followed the document for running Datassist Search and have hit the following problem:
In the example the product ID and Category ID's are related in the Products TABLE. So the example shows adding the recordsets required on the Results & Search pages and them binding the form elements to these recordsets.
So far so good.
However I'm new to this and a little up against it! I need to create a search page (I may also want to add this search facility to the results page at a later date) that allows a user to select / filter products by CATEGORY, by CEREMONY, By PRICE RANGE. I need to understand how to create multiple search criteria, add the appropriate Recordset and bind the correct elements to the page.
I'd very much appreciate your help.