This discussion is archived
2 Replies Latest reply: Dec 31, 2012 1:27 AM by yasser_egypt RSS

forms 6i transaction on every record

yasser_egypt Newbie
Currently Being Moderated
dear sirs,
I have form on table with these fields
1- first_balance
2- month_payments
3- interest
4- net
5- last_balance

i would like to make these transaction for every record
net = month_payments - interest
last_balance = first_balance - net
first_balance = last_balance

please advice me how to do it because i try but not success

yasser

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points