Hello!
I am attempting to setup an access database, and everything that I want to do is pretty straightforward except for the hierarchy piece. We have sales agents who are part of a team that is broken down as such:
State Manager (Top)
Regional Manager
District Manager
Agent (Bottom)
However, the team can change throughout the course of the year, and we need to be able to track the team at a given point in time. For example, if Agent Johnny's District Manager was Bobby the week-ending January 13th, but then Agent Johnny was moved to District Manager Fred's team the week of April 1st, I would want to be able to show/track that Johnny was part of Bobby's team for part of the year, and then moved to Fred's team.
My unique identifier for agents is their agent ID, which is assigned to an agent when they join the company. Has anyone ran across a situation like this that has parts that can be dynamic, and do you have any suggestions on how to work with this?
Thanks!
Amber