Issue: Uncheck previously checked record automatically as when the latest record is Checked.
Scenario:
The Table has a Column (Field) namely "Serial_Number" (text data type) while another field name is "Stock" (Checkbox type). The Serial_Number" field is not unique data type and can be duplicate as we issue the same serial number and get return to/from users. The Serial numbers are of different instruments that we issue and receive to/from the users. Once we issue any instrument we type the serial number of the instrument then user name and then press the "Stock" field (Checkbox). Pressing the Stock field is to mean that the current user/warehouse is having this stock. So, the previously checked Stock field should be unchecked. Because the instrument can only be with one user/warehouse at a time.
Requirement: Since the same Serial Number is inputted many times as we issue it to user and the user returns to us some other time or handover to other user as it requires. So, the checkbox "Stock" should only be checked as being with the latest user/warehouse and the old checked position should be automatically unchecked when the latest issue case happens and the Stock field is checked.
Request: Please help it to resolve to automatically uncheck the previously checked Stock field as when the latest record is checked.
Illustration:
Scenario:
The Table has a Column (Field) namely "Serial_Number" (text data type) while another field name is "Stock" (Checkbox type). The Serial_Number" field is not unique data type and can be duplicate as we issue the same serial number and get return to/from users. The Serial numbers are of different instruments that we issue and receive to/from the users. Once we issue any instrument we type the serial number of the instrument then user name and then press the "Stock" field (Checkbox). Pressing the Stock field is to mean that the current user/warehouse is having this stock. So, the previously checked Stock field should be unchecked. Because the instrument can only be with one user/warehouse at a time.
Requirement: Since the same Serial Number is inputted many times as we issue it to user and the user returns to us some other time or handover to other user as it requires. So, the checkbox "Stock" should only be checked as being with the latest user/warehouse and the old checked position should be automatically unchecked when the latest issue case happens and the Stock field is checked.
Request: Please help it to resolve to automatically uncheck the previously checked Stock field as when the latest record is checked.
Illustration: