AnsweredAssumed Answered

Display totals based on value liat?

Question asked by buck_5648798798 on Apr 1, 2010
Latest reply on Apr 1, 2010 by buck_5648798798


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.




OSX 10.6.3

FMP 10