I have a design for a multi-user database:
1. Form A is used to update Table A and Table B (simultaneously On Click)
2. Form B is used to review Table B, approve records, then delete them from Table B
The problem is if Form B is opened on a record (with Primary Key CASENUMBER) and the record for that CASENUMBER is edited in Form A.
How do I put a lock on a specific record so that if it is being viewed in a form it cannot be viewed/edited in another?