Query from Multiple Tables (1 Viewer)

[camaroltd82]

Hello Again. I need one last peice of advice. (I hope) My storeroom database has 10 tables in it that all have different classifications of parts. I need to have my users search for all of the parts supplied by one single vendor. Since vendors may supply several different types of parts, I can't query off of only one table. Is it possible to query off of all 10 tables at once? Thanks a lot.

Mike Fischer

 

[RichMorrison]

1) See Access Help for "Union" queries.

2) Don't store similar data in 10 tables.

2) is a better solution than 1).

RichM

 

[camaroltd82]

Yes but will I be able to query all 10 tables, or will I have to start over from scratch? Thanks

 

[RichMorrison]

Yes, a Union query can combine data from 10 tables.

RichM

 

[camaroltd82]

Ok thanks, I will try that method.