Search entire DB with a keyword 2

[KColquitt]

I have a File Retention DB that needs to be easily used by all employees. I want a search function on the main page that they can type a keyword in and search the entire database. I have 5 seperate tables; I would like for the search to automatically search ALL of them and bring back all results in a sub-form, they can click on any of them to find the one record that answers their question. I see these searches everywhere-i want one like you have on here. Is this something that is possible?

 

[GKChesterton]

With the now more-limited scope, Duane's UNION query idea is more approachable. (My only objection has been complexity and learning for the newbie.)

KJV1611's idea may be tenable. I'm not good at ganging up OUTER JOINs. (For some reason my attempts tend to result in a 'child' being 'left behind' ...)

The two posts above that are marked off as code, like this, represent decent starting points IMHO.

 

[KColquitt]

I'm going to give it a whirl. Thank you for your help

 

[GKChesterton]

I wonder how the whirl went?

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[kjv1611]

(For some reason my attempts tend to result in a 'child' being 'left behind' ...)

[ROFL2]

--

"If to err is human, then I must be some kind of human!" -Me