subform based on query of multiple tables

S

Seren

I'm having a really big issue and I've gone around and around with this...

I have a form that lets the user enter criteria and then click a "View"
button. The query I am attempting to use has info from 3 different tables.
there is a result table that includes resultID, OpID, OpNum, date, day,
Shift, and panels. The PanelJob table has OpID and Operation, and the
PanelJobDetail table has OpNum, OpID, and OperationDetail. I need date, day,
Shift and panels from the result table, Operation from PanelJob table, and
OperationDetail from PanelJobDetail table. I can get everything but the
Operation and OperationDetail fields. All of these tables are connected
through relationships. I know there needs to be something in the criteria
field of these two like there are for the rest, but it's over my head right
now, I guess.

Does anyone know what I'm talking about, or, more importantly, what needs to
be done?

Thanks!
Seren
 

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

Error 3065- cannot execute select query 8
List all tables, including document structure 0
Query to pull set criteria or all 3
Multiple IIF query 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Creating a Chart on form from selected data in query. 0
query to show where no data in a stated column 0
Double line borders on multiple tables on one page Issues 0

Top