2 Replies Latest reply on Oct 31, 2013 7:05 AM by philmodjunk

    Report Help Please



      Report Help Please


           I am using a standard type invoice setup with 2 database tables, INVOICE and INVOICELINES. INVOICE holds the invoice data, and INVOICELINES holds the products that were ordered. The two tables are related by an IDNUMBER field. when i run the report  I created, only the 1st line of product shows under the invoice line. I have done this type of reporting many times in crystal reports with no problem - cant seem to do it in filemaker. here is how the report should look:

           123     Acme Widgets

                       Widget 1

                       Widget 2

           345     Baker Bananas

                        Banana 1

                        Banana 2

           Any help or code examples would be appreciated. Thanks in advance