AnsweredAssumed Answered

Display line total in a related table

Question asked by buck_5648798798 on Nov 17, 2013
Latest reply on Nov 17, 2013 by philmodjunk


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..