Calculate Balance

jsshivalik

Hi

I have below some of the fields in Database

Location , Date , Amount , Paid Amount , Balance . In Balance field i want its value should get updated by like this

Amount - Paid Amount = Balance. Can we do it at Table level

Thanks

RockWithNAV

Did you tried writing this in OnValidate Trigger of Amount and Paid Amount
Balance := Amount - Paid Amount;

RockWithNAV

Did you tried writing this in OnValidate Trigger of Amount and Paid Amount
Balance := Amount - Paid Amount;