Update field

I am creating a mini bank app i have created deposit form in which the amount deposit and the name of the user that deposit works correctly , where i am having issue is i want to increase customer balance each time a new deposit to the account and i want to reduce the balance of the customer each time their is withdrawal to the account and i don’t want customer to be able to withdraw money when is balance is $100 because minimum that must be in the account is $100 , customer cannot have less than $100 in his account. Thanks in advance

Use the Row_Inserting server event, reject if the amount is below the minimum.

Thanks , what of deposit and withraw do i need to create seperate table for them and in Asp.net make i will just allow edit field in setup table to be visible