How to fix this problem? Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (`northwind`.`employees`, CONSTRAINT `FK_Employees_Employees` FOREIGN KEY (`ReportsTo`) REFERENCES `employees` (`EmployeeID`))

SuiteCRM Forum - English Language Developer Collaboration
, ,
1 
DELIMITER // 
create trigger removeEmployee before delete on employees for each row begin
delete FROM employeeterritories  where employeeId = OLD.EmployeeID; 
end //
DELIMITER ;