I have a database with orders, and per order there can be added items... Database works fine and all, but now I need to print it and it doesn't seem to be possible (I seem to need 2 bodies).

 

Here's a sample of how I need it:

 

ORDER 12345

    12345     Product A     $99.25

    23456     Product B     $24.38

    34567     Product C     $48.78

         98765     Module 1     $5.98

         87654     Module 5     $2.77

         76543     Module 9     $9.18

    45678     Product D     $15.93

    56789     Product E     $36.55

         98765     Module 2     5.66

         87654     Module 3     3.88

 

 

Here's a sample of how I get it:

 

ORDER 12345

    12345     Product A     $99.25

    23456     Product B     $24.38

    34567     Product C     $48.78

         98765     Module 1     $5.98

    45678     Product D     $15.93

    56789     Product E     $36.55

         98765     Module 2     5.66

 

It does not show all related records, only the first one (because it's a summery).

'Products' and 'Modules' are 2 different tables. 'Modules' has a field which holds the unique id to 'Products'. As said, database and portal work fine... Just the report doesn't work.

The report is done by "Sub-Summery when sorted by" in the database of 'Products', so the body holds the records from that database. So I need another body which shows the 'Modules' related to each 'Product'. Am I still clear? ;-)

 

See:

http://fmforums.com/forum/topic/83068-seperating-a-table/#entry385368

http://fmforums.com/forum/topic/78099-report-from-related-tables/page-2#entry366778