Foreign key constraint may cause cycles or multiple cascade paths?

by

I have a problem when I try to add constraints to my tables. I get the error:

Introducing FOREIGN KEY constraint ‘FK74988DB24B3C886’ on table ‘Employee’ may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

My constraint is between a Code table and an employee table. The Code table contains Id, Name, FriendlyName, Type and a Value. The employee has a number of fields that reference codes, so that there can be a reference for each type of code.

I need for the fields to be set to null if the code that is referenced is deleted.

Any ideas how I can do this?

11 Answers
11

Leave a Comment