How do I query multiple Tables with difernet Primary Keys

G

Guest

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.
 
B

Bruce

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

Bruce
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Executing a make-table query using multiple primary keys 8
Multiple tables with same fields 2
query with multiple primary keys 7
Linking multiple tables 5
Non-updateable query issue 24
query multiple tables with identical column names 4
Correct design and primary keys for linking multiple tables 4
Linked Tables Append Query(ies) 4

Top