Database update issue when two different users updating at same time

Hi Experts,   When two different users are trying to update same object in the database at same time.  For Example:  If the default value for an attribute is 0. When user1 updating the attribute value as 1 and user2 is updating the attribute value as 2 . Now the system is updating the value from 0 for both users. But we expect the user2 updating the value from user1 which is 1 and not from 0.   We tried end transaction but it didn't work for this scenario. Please suggest some other solution for this case   Thanks
1 answers

Before the save action retrieve the object from the database to ensure that you are working with the latest values could maybe help you.