Search Page

[stevo07]

Hey there

im tryin to make a search function on a form which searches all the tables I have in my database in 1 single search. I want to do this without having to create a query. Is this possible? If so how do I go about doing this?

cheers!

 

[ted.martin]

Using the DLOOKUP function will work but you will have to code it to look through each table in sequence. The question is what are you looking for in all your tables and what do you intend to do when the search is complete - either found or not found?

 

[ColinEssex]

Also, as the data in your tables should not be duplicated, why the need to search all the tables?

Col

 

[stevo07]

well I work 4 a production company which has a lot of pictures in its archive. My boss asked me to store all the picture info onto a database. Because there were a lot of different types of pictures I needed to make seperate tables for them. He also wanted a search function to search all the tables in one sitting. I didnt think you could do it, but i guess i was wrong. Cheers!

 

[ColinEssex]

Your database is set up incorrectly.

You should only have one table for the name of the film and a field for the category - comedy, horror etc. This will be stored as an ID number drawn from a master category table. Depending on other details like actors / cast list etc depends as to whether you need more tables

You can then search by category, or name, or part name etc. If you want all the films with "love" in the title as a comedy, you can find those.

Col