Hello.... Facing a small problem again.
I have made an outgoing invoice system as such:
- 2 tables: Out_Invoice & Out_Invoice_Line (Out_Invoice is the main body of the invoice and inserted within is a portal field from Out_Invoice_Line which holds all the items to be sold for that invoice)
- Total amount to be paid per invoice is a field in my Out_Invoice_Line table (summary of my subtotals - subtotals being unit price multiplied by quantity per item)
It's working out well for that purpose but now I have to make a "Master Invoice List" layout which should have the Grand Total of all invoices.
I made the Master Invoice List layout associated to my Out_Invoice table - and somehow I can't get the Grand Total Amount. When I try to make a calculated field on my Out_Invoice Table which (as I would want) should get the total of all total amounts (total amounts from Out_Invoice_Line) in all recorded invoices. But it just keeps on showing me the total amount for the last recorded invoice
Do I have to rearrange my tables, or what do I do???