Hello All,
I'm having trouble trying to visualize how to structure my tables for an emplyoee HR database.
I basically want to be able to print "maps" of employee hierercy.. For example:
Level 1:
Manager 1
Level 2:
Manager 1 has the following employees:
Team Leader 1,2,3, and Admin Assistant
Level 3:
Team leader 1,2,3 each have a team of 6 employee's to them.
How would i code such in a database? I want to be able to pritn a report, for example, such that i could select team Leader 1, and it would print all employee's reporting to Team leader 1.
Or, i can print a report for "manager 1", and it would print a report for everyone under Level 2.
Suggestions?
Andrew.
I'm having trouble trying to visualize how to structure my tables for an emplyoee HR database.
I basically want to be able to print "maps" of employee hierercy.. For example:
Level 1:
Manager 1
Level 2:
Manager 1 has the following employees:
Team Leader 1,2,3, and Admin Assistant
Level 3:
Team leader 1,2,3 each have a team of 6 employee's to them.
How would i code such in a database? I want to be able to pritn a report, for example, such that i could select team Leader 1, and it would print all employee's reporting to Team leader 1.
Or, i can print a report for "manager 1", and it would print a report for everyone under Level 2.
Suggestions?
Andrew.