Hierarchical Databases

How do you properly go about rolling up and selecting all users for each parent company until there are no more parent companies?

I currently have supervisory organizations setup with the following:
Organization Name:
Parent Supervisory Organization:
Direct Manager:
Subordinate Employees:
Subordinate Organizations:

The goal is to have supervisors be able to enter performance evaluation and it rolls up to the DGM, RD, VP of Sales, and Excutive Staff. . . I could have it setup to just show all evaluations, but they want to be able to just see their related evaluations based on company hierarchy. . . Help, Please!

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.