a simple form

hi. am very new to navision and am trying to come up with a code to sum up savings in a sacco,

theres a members table that has all member details including monthly contribution and total savings, which should be automatically incremented when a member enters a monthly contribution.

i managed to write a code to pick the member no, and monthly contribution but now i cant write the code to sum them up :frowning:

the form looks like below:

Hiā€¦Welcome to DUGā€¦

I cant see the form.can you check?

ok this is awkward am trying to attach the screenshot iv vain [:(]

anyhow,

You have a table called ā€œmembersā€ with all member details including monthly contributionā€¦

In the same table you have total savings which should be the sum of monthly contributions for same memberā€¦

is it so?

If yes,

Set Total Savings to FlowFiled and CalcFormula as

Sum(ā€œMembersā€.monthlysavings WHERE (Member No.=FIELD(Member No.))) (you need to set exact field names)

yes both are in the same tableā€¦

If yes,

Set Total Savings to FlowFiled and CalcFormula as

Sum(ā€œMembersā€.monthlysavings WHERE (Member No.=FIELD(Member No.))) (you need to set exact field names)

Thank you Mohana! Iā€™m sure this solution worked. Everyone always begins from somewhere indeed!