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