.net - Database cascading error -
I have three tables in my database: Events, Jobs and Collective Antiques. The FK was pointing at the jobs of PK. In both events and jobs, non-blankable FK (which is also PK of the table) for Collective Antilles' PK, these FK relationships are set for a waterfall on updating and destroying. In fact, when you remove Collective Entity, I want to delete the relevant event and / or job. Now I am trying to change Events to Job FK relationship to set tap on updates or delete, but I get the following error: Error SQL01268 : .Net SqlClient Data Provider: Message 1785, Level 16, State 0, Line 1 Submitted 'FK_Events_Jobs' table 'events' may be on 'foreign currency key' Specify an action on the circle or multiple casted path DELETE or an action update Do, or other foreign keys Modify the barriers. Where is the cycle? How can I avoid this problem that the description described above is the only effect I want. (I'm ready to make changes to avoid other ...