There is a column (B) in my grid that is read only and it's value is dependent on the value of another column (A).
What I'd like is for the value of B to be updated when the row is in edit mode (or insert) and the value of A is changed. So for example when the input box for value A changes or loses focus. Because if the value of B isn't retrievable, then the value of A is invalid I'd like to notify the user of this before they save the invalid record.
Makes sense? Can anyone help?
I can see an easy way to do this for insert by extracting the insert from the grid, but I'd like to keep it in the grid if possible to match edit mode.
What I'd like is for the value of B to be updated when the row is in edit mode (or insert) and the value of A is changed. So for example when the input box for value A changes or loses focus. Because if the value of B isn't retrievable, then the value of A is invalid I'd like to notify the user of this before they save the invalid record.
Makes sense? Can anyone help?
I can see an easy way to do this for insert by extracting the insert from the grid, but I'd like to keep it in the grid if possible to match edit mode.