I'm building a database that has 2 tables - Users, and Groups.
I created the 2 tables, and a 3rd table, for a many-to-many relationship, so that
I can track which Users are in which Groups. However, I want to be able to add a
group to another group. Is this possible?
For instance, what I'm tracking, is NT Admin security.
In NT, you can set up your security groups, placing Users in the group, as well
as other groups within the group.
The Many-To-Many relationship does not seem to suit this, since I have no way of feeding a Group back into the group.
What sort of design would it take to get this functioning?
I created the 2 tables, and a 3rd table, for a many-to-many relationship, so that
I can track which Users are in which Groups. However, I want to be able to add a
group to another group. Is this possible?
For instance, what I'm tracking, is NT Admin security.
In NT, you can set up your security groups, placing Users in the group, as well
as other groups within the group.
The Many-To-Many relationship does not seem to suit this, since I have no way of feeding a Group back into the group.
What sort of design would it take to get this functioning?