Query Question

  • Thread starter Thread starter JaneM
  • Start date Start date
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.
 
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?
 

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

Access 2010 query for 3 tables 0
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Trouble with Select Query 2
Primary Keys, Indexes, Relations (inability to update/edit queries 5
Access 2010 Form Issue's 0
Setting up tables properly 1
Use DLookUp to Enter Data into a Table 3
Primary Key & Unique Numbers with Decimals 6

Back
Top