AnsweredAssumed Answered

Report Help Please

Question asked by RaymondMedon on Oct 30, 2013
Latest reply on Oct 31, 2013 by philmodjunk


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