I have a grid containing a column, which when the value of that field is changed, the percentage need to be reflected to the percentage field.

For example, I have this:

Value    Percentage
50          22.220
40          17.780
50          22.220
50          22.220
35          15.560

So, whenever the value changes, I do a scan of the grid to replace all the percentages.

My method basically calculate the somme of all values and do a SCAN to apply the percentage.

At the end of this, I move the pointer to the record the user changed the value.

Then, I press the arrow down to move to the next record. I try to type a value and I have the message saying record is locked by another user. The alias of the value and percentage fields is having buffering 5.

Any idea?