468,242 Members | 1,467 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

cyclic cascade paths

Hi,
i have tree tables in my db, one for menu, one for menu items and the other authorization.. They have the following columns and relationships:

Menu
-----------------
id (PK), name, position

MenuItem
---------------
id (PK), name, parent (FK to Menu->id), position

Authorization
-------------------
id(PK), menuid (FK to Menu->id), menuitemid (FK to MenuItem->id), usergroupid

By doing this a user group will be authorized wholly for a menu of for just a few of the items in a menu (meaning that each record of the authorization table will either contain a value for menuid or for menuitemid). I defined cascade delete/update between menu and menuitem tables and menu and authorization tables. However when i try to define a final cascade delete/update between menuitem and the authorization tables, i get the cylic cascade path errors from sql server.. What could be the solution..
Thanks
Sep 23 '08 #1
0 1001

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Thomas Mailund | last post: by
2 posts views Thread by Gunnar Vřyenli | last post: by
reply views Thread by Rob Panosh | last post: by
3 posts views Thread by SuryaPrakash Patel via SQLMonster.com | last post: by
3 posts views Thread by Dennis Lerche | last post: by
2 posts views Thread by Matthias Kramm | last post: by
3 posts views Thread by fc2004 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.