Looking for updating existing value

Hello,

I have following categories: Expense Category, Name, Amount. I want to have the following to be done.

If user selects Expense Category as "Travel" and Name "Gas", I need to present user an empty Amount, which gets added to the exisiting Amount and then shows that value after the form is saved.

Let's say, already i have  Expense Category as "Travel", Name "Gas" and Amount as some 20. Next time when user wants to add new row with Amount 30, and selects Expense Category as "Travel", Name "Gas", I do not want a new row, but just add to existing amount 20 and show as 50.

Please help me with this.

0 0 27
0 REPLIES 0
Top Labels in this Space