A simple calculation problem.
FM Version: 16
Tables 1: (Primary Table holds Annual Membership Fee)
Table 2: (Secondary – MANY TABLE – holds Members multiple payment data)
Relationship: Member ID with Member ID
What I am trying to do is:
Generate a report which gives me the Total Payment by each member and the Balance Due on each member.
Also want to print out a report Balance Due = 0
Another one with Balance Due list > 0
Somehow my calculation is not giving the right Balance Due amount.
Also the Grand Total of the Membership Fee