The error you are getting is because you are reading and then modifying the record after it was already written. Then in your screen, you don’t have the latest copy, so you get the “modified by another user”. the system doesn’t know who modified it… just that it has been modified. How does it know this? Well, there is a field called RowRev, which is an integer number… it is increased each time a change is made. when you attempt to change the record again, we look and if the value is higher in the database than the value you originally read, we know that something else changed it.
Now, back to your original problem: There are TWO types of data directives… one is the “standard” and one is the in-trans… if you change to the in-trans, then you are modifying the value that is in memory BEFORE it gets written. so… if you read and modify that in-transaction temporary value before it gets written, you should not have this problem.