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