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.