I have a case where a user can be modifying a record and another user runs an app and copies the record anyway. Example. My usewr is in there editing record number 14. They have not hit save yet. Another user runs an app and record 14 applies to what they want so the app copies the record to another table. The app should then go back and delete the record in the previous table but does not. I thought I had pessimistic choosen as a whoe in my preferences but maybe Iam missing something. The result we have now is that the record in in both tables and can be accidently edited and sent out again. Any wayb to assure that if a user is using a record that another app or person can't come along and get it?

Thanks in advance for your help. Happy holidays.

Randall