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!