Multiple relationships with cascaded delete.
I managed with no problems to creat a relationship between TableA.FieldA and
TableB.FieldB with cascaded delete. However, when I tried to create a second
relationship between TableA.FieldA and TableB.FieldC I got the message:
- Unable to create relationship 'FK_TableB_TableA'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN
KEY constraint 'FK_TableB_TableA' on table 'TableB' may cause cycles or multiple
cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify
other FOREIGN KEY constraints.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint.
See previous errors.
The database I am trying to create is one that was originally in Access,
which had no problems with this type of multiple relationships. How do I
upgrade, or is it impossible?
Thanks in advance to anyone who can help me out.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL