[thelist] recursive database design discussion

[rudy]

hi jacques, sorry for the delay in answering

the second method is better -- use a recursive structure rather than
separate tables for organizations, departments, and groups

yes, the queries to access the same table three times will be tricky, but
they will be no more complex than the queries involving three separate
tables

there are plenty of examples on the web for code to process the recursive
hierarchy, holler if you need any of them

queries such as which user has access to which group are actually simpler

rudy