2 Replies Latest reply on Apr 1, 2010 6:20 PM by buck_5648798798

    Display totals based on value liat?

    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