Please help database expert
I'm using SQL 2000 server.
My program can let user to define more than one company's organisation hierarchy. for example:
CompanyA
Account Department
Budgeting
Purchase Department
Good Receiving
CompanyB
Account Department
Purchase Department
There is not limit for user the define the company in the hierarchy level veetically but only five level for horizontally( such as ( comp1\acc\budget\group1\team1)
After the user defined it, they will allocation their employee into hierarchy acordingly.
I really confuse how to model such a relationship