AnsweredAssumed Answered

Problem with printing from two related tables

Question asked by BigMike on Nov 19, 2008
Latest reply on Nov 19, 2008 by Kundinger

Title

Problem with printing from two related tables

Post

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:

Job ID
Room ID
(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.






Outcomes