Creating Two Cascading Foreign Keys Against Same Target Table/Col
- by alram
I have the following tables:
user (userid int [pk], name varchar(50))
action (actionid int [pk], description nvarchar(50))
being referenced by another table that captures the relationship:
<user1> <action>'s <user2>.
I did this with the following table:
userAction (userActionId int [pk], actionid int [fk: action.actionid], **userId1 int [fk ref's user.userid; on del/update cascade], userId2 int [fk ref's user.userid; on del/update cascade]**).
However, when I try to save the userAction table i get an error because I have two cascading fk's against user.userid.
Is there any way to remedy this or must I use a trigger?