I want to know if there is a more direct way to do this?
I have a form that includes multiple subforms. Some subforms may be empty for the record in the main form. I am trying to put everything on this main from into a query, where everything is displayed in a query.
All the subforms are M:M from the Main table.
1:What I have done is query the Main table by CustIdD to the Details Table by a Left Join. 2:Then I took that query and queried it against the orders table. by order number, using a right join. 3:I see all the Customers even though they may not have an order, which should be correct. That is 1 subform
For the other subforms, I repeat steps 1-2.
Finally, I query the all last queries or step 2 queries with one another. Near the end something looks right but it doesn't. Is this the correct way of doing this type of query?
Only join the tables ONCE AND ONCE ONLY. Just because you have four subforms on the form doesn't mean you need four seperate queries. Subforms are basically just a join statement, that's it. If you give the FULL rundown of your table structure, we can help you with that.