Can this be done using multiple tables.
I have been attempting to create a similar function.
Basically search for a business profile based on selected check boxes/Radio buttons and drop down lists. However, in my case I have the data in distinct tables.
IE: One table holds the company contact data, another holds the courses they offer.
I want to find all matching companies to the search query, then display each company using repeat record set. The issue I run into, is when trying to display the company I can only display one course they offer, I am not able to select multiple rows from the courses table that match.
I don't expect the pro's like Jason to solve this for me, however if you could enlighten me if this is even possible it would be a great help. I have read that WA is not able to work with multiple tables using DataAssist.
If there is a PHP / MySQL expert who would like to take this on as a side project, educate me and solve the search issue, I would love to outsource it to you.
Thanks in advance - Jerry
