adding in a table field

subrata.bauri

I have a table name table1 and its fields are value1, value2 and Total.
I want that when I am inserting values in the fields value1 and value2, the Total field calculates the (value1+value2) and show the result.


Is it possible?How??

HalMdy

In trigger OnValidate of field Total, put the calculation like :

total = Val1 + Val2


for each Val field, in trigger OnValidate, put :

VALIDATE(Total);