i have a table that contains 3 forign keys ,
2 of them from the same table
when i make Delete Rule Cascade,this error message appears
'Customers' table saved successfully
- Unable to create relationship 'FK_Order_Customers1'.
Introducing FOREIGN KEY constraint 'FK_Order_Customers1' on table 'Order' 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.
what is solution,as i want when i delete data from master table ,all dependent (child) data
automatically deleted, so i use Cascade
View Complete Post