How do I query multiple Tables with difernet Primary Keys

[Glenn]

I have 7 tables in an inventory database with differnet primary keys. The
keys are based on what is being inventoried. Each table has a common field
called SerialNumber. What I want to do is create a query to search each table
for a matching to the serial number that the user had inputed. Not sure if a
query is the right way to go. Any help will be much appriciated.

 

[Bruce]

Use Relationships to join serialnumber field then you can combine the
various fields from each table in a query.

Bruce

 

[Glenn]

Established a relationship to join serialnumber feild and created a query to
pull out the serial numbers, however the results are blank. Not sure if I am
doing it wrong. Thanks for your help and I will keep trying to figure out
what I am doing wrong. If you have anymore ideas or have an idea of what I
could be doing wrong I am all ears. Again thanks.

Glenn