Problem with printing from two related tables
I have developed a database for my wife's window treatement business. I am experiencing a problem when printing.
Here's the scenario:
I have a table called Rooms and two related tables, Soft Items and Hard Items. Basically Soft and Hard Items are both related back to Rooms via Room ID (Room:Room ID --> Soft Items:Room ID and Room:Room ID --> Hard Items:Room ID).
I am unable to get more than one item from Soft Items or Hard Items to print on a report. I have the following summaries in the layout:
(Soft) Item ID
(Hard) Item ID
I am sorting the layout by these fields before printing. However, when I print I am only getting the first item from Soft Items or Hard Items.