I have an Employee table with a yes/no field for "Employee Allocation".
I have an employee allocation table that stores the percent and the "to department".
On the Employee form, they can check yes for the allocation and then go to another form to enter the allocation percent etc... and this information gets stored in the employee allocation table.
I want to create a way to automatically delete the data stored in the employee allocation table if the employee allocation was changed to no.
Any help would greatly be appreciated. Thank you.
I have an employee allocation table that stores the percent and the "to department".
On the Employee form, they can check yes for the allocation and then go to another form to enter the allocation percent etc... and this information gets stored in the employee allocation table.
I want to create a way to automatically delete the data stored in the employee allocation table if the employee allocation was changed to no.
Any help would greatly be appreciated. Thank you.