Symptom
Changing an Employee ID in Payroll results in error The UPDATE statement conflicted with the REFERENCE constraint “tblPREEDirectDep_FK00”. The conflict occurred in database “ODUR”, table “dbo.tblPREEDirectDep”, column ‘SEmployeeID’. The UPDATE statement conflicted with the FOREIGN KEY constraint….”.