April 14, 2003 at 8:17 am
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
April 17, 2003 at 7:26 am
assuming a unit has only one "parent"-unit, you could have an entity "company" an other entity "Units" with a relation to "company" and a third entity "UnitRelations" where you decoment the relaton "dependant"-unit to "parent"-unit (watch out for "intercompany"-issues). You could materialize an hiarchy-"explosion" if needed.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 17, 2003 at 7:28 am
erata : "decoment" should be "document"
/ "relaton" should be "relation" 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply