-
Hi all!
I have to build this search page for this website I'm working on. I have multiple fields in multiple tables that I want to search through. All tables and fields have been enabled for full text index search.
Is there a way I can search all those fields in all those tables in 1 query? If so, how?
If not, then I thought of another way to do it, namely search the different tables in some sort of loop-structure, and then just add the results to an overall result recordset. So I've been wrestling with this idea, but I can't seem to get it to work.
Any help would be highly appreciated.
Thanx, Marcel
-
I'm not sure if this is the good way (depends on the amount of data you have) but you could throw everything in a view and query that?
-
Would that keep the full text index search possibilities then on all different tables?