No sir, my balance is just a calculation field in my query.
What I want sir is that, When the user only Enters the Amount_Tendered I want my Amount_Paid to automatically fill the equal Amount as Total Balance or (Amount_Paid:Amount_Tendered-Change)
in my query code(Balance:Amount_Due+Penalty-Amount_Paid).
I want this to happen coz I dont want my User to fill up so many textbox,
I want the user to just fill the Amount_Tendered.
and click save.