You need a payments table, with
member_ID, payment_date, amount_paid
the member table sees the records of the payment table via a relationship and can show them in a portal.
A summary (total of) field must exist in the payments table, and it can be displayed on the member layout.
1 of 1 people found this helpful
Thank you very much for your help
Am able to do that but how can filter portal by date eg from 2/12/2014 to 4/11/2015
You may want to mark siplus's response as helpful, not your own one ...