Creating a search form

[stevo07]

hey guys

I want to create a general search engine inside a form. I have 6 tables that I want to search all at once by using one single search text box. I also want the function to search all the fields contained in the tables. I also want to make option tabs so the user can select the specific tables s/he would like to search. Finally I want the results to be shown in a report.

heeeeeeeeeellllpppppppp!!!!!!

cheers

stevo!

 

[MarkK]

Oh, that's it?
You want to make a table of the tables you want to search and a table of the fields you want to search in each table. Then you can dynamically construct SQL statements based on the scope of the search and the user specified search criteria.
That's where I'd start.
For more specific answers, ask more specific questions.

 

[Luddite Lad]

Perhaps the search tool in this thread is what you are looking for?