One keyword search for multiple tables?
I'm having a bit of a time getting the Data Assist Search to function as desired with multiple tables, and would appreciate any help getting this resolved:
I have a mysql database with multiple tables of different content which drive a site: individual page text, event information, documents available for download, posted images & videos, etc.
I am trying to create a single, sitewide keyword search that will search through each of the chosen tables and return accurate results from only the relevant table(s) in a coherent & linkable manner.
This works great with one table, but fails every way I've tried it with more than one table (one recordset pulling from all tables, one recordset for each table, etc.). My most logical approach is to make separate recordsets for each table on the search & results pages and then somehow get the search to look through each recordset in turn for results, and use a 'show if table not empty' on the results page for each of the tables.