search function

[stevo07]

hey guys,

Ive been trying for a while now to create a search function that can search up to 6 tables in one basic search. I also want to be able to select which tables I want to search by use of option buttons and I want the results to be shown in a report. Is this possible to do, if so how.

Take a look at my database and look at the searchAllForms2 form and then you'll see what I want.

Cheers

Stevo

 

[Luddite Lad]

Stevo

From looking at your DB, it seems to be a catalogue of various media resources. There seems to be many common elements to each table. Why not store all your records in one table and then have a field to differentiate each type of media?

This will then greatly simplify the search process.