How do you Read and write to Two Tables As one!??!

[Sly600rr]

Please somebody tell me if what I'm trying to do is possible, I'd hate to be trying something that can't be done.​

I have 2 tables..​

One table has my main order information.
my second table has mutiple records that pertain to that one order.​

Table1
Order #1
Part# Lot# Order# Qty PO# ect..​

Table2
Order #1
#1 Nonconformance
#2 Nonconformance
#3 Nonconformance
ect..​

I have a form for inputing data into both tables at once using a continous sub form for my Table#2 data​

I want to be able to seach for the data using a form to build a filter for my query.
But my query will only return 1 of my results from table#2 instead of all of them.​

I can't figure out how to pull the data back into a subform together!!​

Can I do this with one query? or do I have to use 2 querys (one for each table) and if so, how can I do a search and include both querys?​

I'm completly lost!! and in over my head!! ​

 

[boblarson]

I know you don't want to hear this, but your design is flawed. You should not have repeating fields (#1 Nonconformance, #2..etc.). You need a different table setup to handle a one-to-many or many-to-many relationship.

Perhaps you should read this first:
http://www.allenbrowne.com/bin/Access_Basics_Crystal_080220_Chapter_03.pdf