Hello,
There are three tables:
OS-GroupOFCompanie s (Table1)
GoC_GroupOFComp aniesID (PK)
OS-Organization (Table 2)
Org_Organizatio nID (PK)
OS-UnitAddress (Table 3)
Unit_UnitAddres s (PK)
Scenario:
(1)GoC_GroupOfC ompanies has -one to many- relationship with Org_Organizatio nID.
(2)GoC_GroupOfC ompanies has -one to many- relationship with Unit_UnitAddres s.
(3)Org_Organiza tionID has -one to many- relationship with Unit_UnitAddres s.
Following Error message appeared after trying to save the relationship (3) described above.
'OS-Unit-UnitAddress' table saved successfully
'OS-Organization' table
- Unable to create relationship 'FK_OS-Organization_OS-Unit-UnitAddress'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN KEY constraint 'FK_OS-Organization_OS-Unit-UnitAddress' on table 'OS-Organization' 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.
NB: ON UPDATE is much needed.
How to manage the situation?
Please guide.
Thanks
SuryaPrakash
*************** *************** ***********
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse....935efcabb55ee9
*************** *************** ***********