Multiple Users Accessing the Same Records


I had a question regarding having multiple users logged in accessing the same records simultaneously. What do you think the best approach to having the users be able to save records without clobbering each other's changes. We have multiple people accessing records at the same time on the same tables. Sometimes their edits can take some time, and I wouldn't want them to lose their progress. I was going to build a locking mechanism (a Locked field on the database tables), but didn't want to go down that path if anyone had a better suggestion.



This article might help you in your case: