By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,787 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

cyclic cascade paths

P: 26
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
Share this question for a faster answer!
Share on Google+

Post your reply

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