Training database - storing hierarchical structure

[scubadiver007]

Training database - managers and departments

Hello,

I feel stuffed over a problem. Companies have a hierarchical structure of managers and departments (CEO down to humble employee).

My colleague will want various reports for each head of department and team.

I had decided on a tick box in the employee form to specify the employee is a line manager and then use the list as a source for a combo box.

Then I thought about having a separate table.

Any suggestions? Ever come across this kind of problem? It is a bit tricky.

Thanks in advance

 

[cookiegary01]

Hi, What you want requires a lot of explanation,a lot of knowledge and a lot of patience.
Even then, many changes can take place in a company, and you may have to rebuild the databse frequently. Just a few tables and a tick box is not enough.It goes much much further than that.
This kind of request has been handled before here. You have not received any reply, (my point of view), due to the above.
Perhaps you should reconsider doing it in a database untill you have gained more database knowledge/experience?
Anybody else prepared to give more advice?