Design issue: nested menu options / hierarchy

Design issue: nested menu options / hierarchy

Post by Tek Bo » Fri, 04 Jan 2002 03:19:33

The problem before me is a design issue, and not a technical implementation
problem.  Right now, I'm attempting to tackle file management via ASP, ADO
and SQL Server 2k................ each profile consists of a title and
description, belongs to at least 1 department, and has linked beneath it a
number of documents (XLS, DOC, TXT, PDF).  Below is one of the key
relationship tables which links it all together:

Table FormProfile_FileMaps
formID int (FK to the table which stores profile title and description)
fileID int (FK to the table which stores virtual path to and name of the
deptID int (FK to the department this profile is being attached to, e.g.
"Human Resources")

Even though I'm a relative novice at RDBMS design, this seems like a decent
way to store the data.  The problem comes in when I try to address which
users should be able to see each profile.  Below is a logical tree structure
of the permissions which any single profile might be assigned:

+ Human Resources
          + Forms
                    + Internal Forms
                              + Public Forms
                                        + Union
                                        + Non-Union
                                                  + Exempt
                                                  + Non-Exempt
                              + Private Forms
                                        + < ... >

My dilemma here is: what is the best way to a) store this data, and then b)
link it to each profile (as loosely defined in table FormProfile_FileMaps)?
Keep in mind that a user can have any combination of parent or leaf nodes --
and selecting a parent node will automatically select all the nodes below

I'm really having a hard time conceptualizing how to do this.............
any ideas or hints would be mucho appreciated.  TIA..................

-=Tek Boy=-


1. Hidden Menu Options in FourGen-Menus

Hi FourGeners,
Can somebody enlighten me what are Hidden Menu Options and how can I use'em?
That is not obvious from manuals.
I'd like to have possibility to run menu item, which one is not displayed
on a menu, but has Item Instruction File in the currentmenu directory

Thanks in advance,

2. How do I include column?

3. Using Foxpro Menu options in my menu

4. Me.chkFields and Me.txtFields

5. Nested Hierarchy

6. Oncheck - error

7. Compacting a nested set hierarchy

8. JDBC comparison?

9. SQL Server Nested Sets & Hierarchies Paper

10. pro's and con's of the nested subsets model for hierarchies

11. FileMaker menu hierarchy

12. Employee Table Hierarchy Issues

13. Nested READs and menus