Table design

[Ben]

Hi all -

I have a list of employees and I wanted to know if you can share with me how
best to design the table so that it implicitly reflects the hierarchy.

The list of employees contains employees from multiple division.
1.Each division has a division head
2.Below the division head, is a department head, there can be multiple
departments within each division.
3.Within each department, there can be multiple groups.
4.Each group have its own manager
5.Below each group are the individual employees belonging to each of the
groups.

I would like to design a table that would reflect this hierarchy:

.........................Corportate Division head
........................./ \
......................../ \
......................./ \
..................Division Head1 Division Head2
................./ | \ / \
............... / | \ / \
............Dept1 Dept2 Dept3 Dept1 Dept2
.........../ | \ | / | \ / \ / \
........../ | \ | / | \ / \ / \
.......Grp1 Grp2 Grp3 Grp1 Grp1 Grp2 Grp3 Grp1 Grp2 Grp1 Grp2


The Grp numbers in each department are not related to the same Grp number in
other Departments..

Thanks for sharing your thoughts,

Ben

--

 

[Pete D.]

You might find this interesting
http://allenbrowne.com/AppHuman.html

 

[Ben]

Thanks Pete.

Ben



--

You might find this interesting
http://allenbrowne.com/AppHuman.html

 

[Ben]

Steve,

I am finally able to see the post. Thanks for tip.

Thanks,

Ben