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

Title

Display totals based on value liat?

Post

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.

 

Thanks!!

 

OSX 10.6.3

FMP 10

Outcomes