Query Question

J

JaneM

I am trying to create a query to retrieve jobs numbers from a
database in which the primary key is Job#. The primary key
is the same in 13 tables I have set up. Can this work?
Can you give me a sample or solution? and what about
relationships? Do they have to be set up in advance.
 
K

KARL DEWEY

I do not know what you are doing but most probably there should be only one
table. You can use a union query to pull the data together.

But how can you segregate and use information when as many as 13 have the
same job number?
 
Top