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