Employee HR Database (Employee Hierarchy).

andmunn

Registered User.
Local time
Today, 14:07
Joined
Mar 31, 2009
Messages
195
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.
 
Thanks for the help.

I tried downloading the file and i get this message "The document must be published before downloading. ".

Advice?
Andrew.
 
I tried downloading the treeview Sample and the never did get to the Treeview, but was taken to other download offerings. I never did see the Treeview Sample.
????
 
Andrew,

Sorry about that. I have it published now. It is ready for you to download.

Boyd Trimmell aka HiTechCoach
Microsoft MVP - Access Expert
 
andmunn,

Boyd's structure for the staff table will do exactly what you need.
 
Thanks!

That table structure (tblstaff) looks like exaCtly what i need.

My question, how do i write a query such that (for example):

tblstaff
ID / Name / Reports To

1 / John Doe / 4
2 / Bill Smith / 1
3 / Jane Orielly / 2
4 / Boss / <blank>

If i wanted to write a query to show everyone reporting to boss, how would i write it?

Results would be something like:

Boss > John Doe > Bill Smith > Jane Orielly

Andrew.
 
I am not able to open the above mention'access treeview example'. It is giving me forbidden error. Could you please share the example in different format or via mail
 
I am not able to open the above mention'access treeview example'. It is giving me forbidden error. Could you please share the example in different format or via mail

Try the link now. It should work.
 
As per andmunn posted on 06-22-2011 12:01 AM, Can you help us to code the hierarchy model or the query as per the below example:
1 / John Doe / 4
2 / Bill Smith / 1
3 / Jane Orielly / 2
4 / Boss / <blank>

Many Thanks.
 

Users who are viewing this thread

Back
Top Bottom