|
uniservice
Starting Member
1 Post |
 Posted - 2012-09-04 : 09:17:28
|
| hi alli have tables like belowtbl_users:id , uname , pass , ...tbl_sp_posters:id , uid , pid , title , body , ...tbl_Free_Posters:id , uid , pid , title , body , ...tbl_Text_Posters:id , uid , pid , title , body , ...tbl_Img:id , spid , frid , txid , imgusers table have relation with (tbl_sp_posters , tbl_Free_Posters , tbl_Text_Posters) tables ,and Delete Rule , Update Rule is Cascade in these relations.tbl_Img have relation with (tbl_sp_posters , tbl_Free_Posters , tbl_Text_Posters) tablesbut when i'll enable Delete Rule , Update Rule in this relations it give me this error:Introducing FOREIGN KEY constraint 'FK_tblImg_tblSPPosters' on table 'tblImg' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.Could not create constraint. See previous errors.where is my problem and how i can fix it? |
|
relation problem between tables