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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center