I use Mysql with MyDac component.
The software is used simultaneously by many users. The customer wants so as if a user navigates to a record (a customer sheet) then he can modify the record, but the second (and 3d etc.) users who click on the same customer would see a message (this record is locked by xy user) and they shouldn't be able to edit it.
When the first user navigates away then another user can edit it.
How can I do this?