Hi Jason, for the second option I have 1 query that contains all the columns I want to search on eg; CaseID | Advisor | Month | Status | Source | Commission
Could I not point the wizard at each of these fields within 1 recordset or would I need to duplicate the same recordset 5 times?
In my testing I have done this;
1 - create new php page, create the recordset with all fields required and insert into dynamic table.
2 - Run the wizard choosing this recordset & mysql, opt to create new search form.
3 - When I am prompted to select fields to add to search it seems to have pulled through all fields from every table rather than the basic 6 from my recordset.
4 - I push on and choos finish, this creates a new search form.
5 - Running this gives me a select field as chosen but with no data in, when I look at code its just a basic form with a simple select, no other code?
Am I missing something, do I need to create the search form manually and add all search code to it?