Unanswered: Finding all occurences of items linked to OrderID on a Report
I've created a report which prints an invoice. It's recordsource is a query which finds the last OrderID that was created. I then look up Customer Info and Products using that info. The problem I'm having is that a customer may order more than one item and my report is only returning the first item order.
In my OrderDetails table I have these fields:
OrderDetailID (Primary key)
For every OrderID, there could be several entries with different ProductIDs. How do I pull in all ProductIDs associated with one OrderID on the report?
I am using DLookUp to find the ProductID of the last OrderID created on the report.