2 Replies Latest reply on Nov 17, 2013 5:59 PM by philmodjunk

    Display line total in a related table



      Display line total in a related table


           I'm making a fairly simple invoice system. I have a layout with a list of invoices that included their cash totals. These cash totals are the total of line entries for a particular invoice.  I can't figure out how to display the total of all the invoice totals in the list. 

           I have 2 tables. invoice and invoice_lines. I created a summary field in invoice_lines that adds up all of the totals. I need to display that info in the invoice list that is based on the invoice table.

           For example. if I search for unpaid invoices, I need a field that displays the cash total for the results..