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

1) See Access Help for "Union" queries.

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

2) is a better solution than 1).

RichM

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

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

RichM

Ok thanks, I will try that method.