You could use a Grouping level in the report for the order (grouped on OrderID) and show the payments for each order in the Detail section.

Yes, I agree but my question was does Richard ever come back and cover this specifically in the remaining lessons?  In addition to grouping, there's also the running balances.  It's a complex report and was curious if Richard addresses this specifically in a future lesson as anybody who has customers will always need a report of a customer's order history and payments for statements.

I think I may have figured it out but would appreciate any comments anybody has.  I believe the customer account statement would work by combining the order entry system and the concepts from the check register TechHelp video.  Thinking like an accountant, instead of "check register", you create a General Journal table like GenJournalT.  From there you encode an SQL function "INSERT INTO" within the AfterUpdate VBA of the payment form created in ACD 7 that takes details from the payment entered and inserts the relevant data into the general journal table as a credit.  The orders (invoices) themselves would be debits inserted upon saving the OrderF (Invoice).  A statement then becomes a report based on a query on CustomerID with DSums for debits/credits and a running balance.  I'm trying to use all my legos I have so far, can anybody comment on this?