Make Staff ID (STF.ID) editable
We have a need for the staff id (STF.ID) to be editable. I understand that it is linked to many tables but I am hoping that logic can be created that would update all related tables when STF.ID is edited.
The Staff ID field (STF.ID) is not editable because it is a unique identifier (primary key) for a staff member, so we do not plan to add any functionality to edit it at this time. This is similar to course IDs which cannot be changed. What can be done is a new staff record could be created and then all references to the old staff ID be changed if absolutely necessary.