Report from Form & Subform

[vlbridge]

I have a form with order information and within that form there is a subform with order details. For each order, there may be several different items entered in the order details subform. These two things populate two separate tables. I have a query called order details extended that puts it all into one table. However, it only lists the first item in the subform. I am trying to create a report that will have the order information at the top and the items listed below, just as the form shows it. The problem is, it only lists the first item, just like the query. I have a button on the form that says "Preview Order" that opens the report, but I need it to show every item. Am I missing something? Please help. Thank you in advance!

 

[vlbridge]

Nevermind. I figured it out. I had the relationships set up incorrectly. Once I fixed that, it laid out in the report exactly how I wanted. Thanks.