Maybe you have found the problem with multiple users concurrently editing and updating the same record. I came across this when I implemented a “get next lead” function for a company a while ago. I created a simple VF page comprising a single button that will find the next lead to work on (using an ordered SOQL query in the controller) bringing up the detailed edit page of that lead.
Latest blog posts written by our professionals.
Salesforce Data Model Poster