I've been tasked by my organization to develop a Calling Tree application. I am a fairly well versed Access and VBA user but am having some difficulty grasping how I should set up the DB for reporting. Here's my problem...
My orgainzation (about 900 people) is set up into multiple groups (as most are). Some groups are fairly straight forward. They go from Director to Group Manager to Staff. However, some groups go from Director to Group Manager to several "lesser" managers to staff. Some other groups go even deeper than that (up to 6 levels down from the Director). To make matters worse, some of these groups are multi-tiered. Here's a crude visual interpretation...
Director
Group A Manager
Group A Sub-Manager 1
Staff
Group A Sub-Manager 2
Staff
Group A Sub-Sub-Manager 1
Staff
Group B Manager
Staff
The reporting difficulty stems from not knowing how many groupings to set up in a report and at what level the Detail section will appear.
Some Groups will go down five levels of managers before you hit the staff (Detail section) while others only go one level down.
It is a simple one table setup. The table has basic contact info for each employee along with the Group they belong to and a field denoting which other employee calls them in the call tree.
Any thoughts...?
My orgainzation (about 900 people) is set up into multiple groups (as most are). Some groups are fairly straight forward. They go from Director to Group Manager to Staff. However, some groups go from Director to Group Manager to several "lesser" managers to staff. Some other groups go even deeper than that (up to 6 levels down from the Director). To make matters worse, some of these groups are multi-tiered. Here's a crude visual interpretation...
Director
Group A Manager
Group A Sub-Manager 1
Staff
Group A Sub-Manager 2
Staff
Group A Sub-Sub-Manager 1
Staff
Group B Manager
Staff
The reporting difficulty stems from not knowing how many groupings to set up in a report and at what level the Detail section will appear.
Some Groups will go down five levels of managers before you hit the staff (Detail section) while others only go one level down.
It is a simple one table setup. The table has basic contact info for each employee along with the Group they belong to and a field denoting which other employee calls them in the call tree.
Any thoughts...?
