Display totals based on value liat?
I making a basic invoicing system for my business.
There are 3 tables. Clients--->Invoice--->Lines
The invoice layout has a portal for clients and one for lines. There is a Total field that adds up the lines for that invoice.
Here is where I'm stuck:
The invoice layout has a value list called Status. It contains billed, unbilled and paid.
I want to create fields in a separate layout that display the grand totals for billed, unbilled and paid.
I also want to filter the totals by client - I would like to put billed, unbilled and paid fields on each clients record.