I missed the original post, but I think you both might want to do some
googling on nested set.
Robert Treat
On Tue, 2004-11-09 at 11:40, Garris, Nicole wrote:
> We've actually implemented this kind of thing in a different DBMS. The
> physical design consists of a single "organization" table that
We've actually implemented this kind of thing in a different DBMS. The
physical design consists of a single "organization" table that's something
like:
Org_key (primary key)
Org_type (group, company, etc.)
Org_level (group is 1, company is 2, etc.)
Org_parent_key (foreign key to or
