How to make a Order and Order Items report
I have two tables:
Orders:
OrderID
Name
Address
etc.
Order Items:
Item ID
Item Name
Qty
etc.
How do I make a report that shows the Order and then all the Items on the Order?
In the Detail Band, I can only see one record, not all the records in the Order.
Thanks,
Scott