Thank you. I will take a look.

One idea I had was to create a database of locks that is checked when users select to change something. This can be groomed automatically with a timer as someone said they do and it can be used to notify the user that the record is currently in use by so and so--also provide an overide mechanism.