AnsweredAssumed Answered

Summary Field Question

Question asked by braxton on Nov 2, 2013
Latest reply on Nov 2, 2013 by braxton


Summary Field Question


     I have a list of customers.  They are all committed to pay for 12 months of service.  Some pay monthly, every two months, every 3 months, and even one that paid 12 months in advance.

     I have a related table to the client table called PaymentAccounting that shows each payment made by a client and how many months that payment represents - QuantityMonths.  I create a record for this table through a portal for each client in the client table.

     Regarding the QuantityMonths field that shows how many months a payment represents, I would like to see its total for each client.  For example, the 3rd payment of a client that pays two months at a time would have a QuantityMonthsTotal field value of 6.  How can I do this and have it show in the PaymentAccounting table.  Any help is much appreciated.  Thanks.