double entry of record from workstations
Scenario 1. Two workstations with same file opened on server.
WS1 is updating a record, says to WS2, "have a look at record #20 and tell me what to update"
"OK, I have it up, just type in such and such" Job done...
So they both move on to other records, no indication there is a problem,no drama.
Result is that unbeknown, FM12 has made a new record, one updated, one as original.
Scenario 2. Invoice records being updated, two workstations land on the same record by coincidence, both update and move on. FM12 has created an extra record for that customer.
How do we overcome this problem?