Update
Ray,
Everything you have suggested worked perfectly, i have am able to search multiple tables and fields using this method..
The only problem is after setting a union, dreamweaver or dataassist doesnt recognize the query, so i just copy and past out my query with a simple one to make adjustments to my search and then past it back in when im finished.
All works perfectly..
I do have one question though, when someone clicks on the search results page, i want NO results to pop up instead of ALL of the results ( for a blank search). How would i set this in dataassist?