We have a set of tables: Customers, Orders and Order Items. Each Customer has only one Order and each Order has one or more Order Items. The Order Items table has a column for the ID of the Order. We are able to create a report that groups by the Customer and shows the Order Items. However, we've been asked to create a single label for each Customer containing all of the Order Items in their Order. This does not seem possible as the Label wizard doesn't provide any grouping options. Am I missing something?
