A method and system of providing access privileges to records of members of a community may comprise storing an assignment of a member of a community to a first position in the community to generate a first relationship. Access privileges to records of the member may be automatically provided to a manager of the first position based on the first relationship. An additional assignment of the member to a second position in the community may be stored to generate a second relationship. During the pendency of the additional assignment, a manager of the second position may be automatically provided with disparate access privileges to records of the member based on the second relationship.