• Management structure / family trees

    Author
    Topic
    #356821

    I am looking for ideas on how I can display an employee relationship in a form using Access 97. I have one table that stores all staff details. I have related an employee to their manager by employee IDs and managers IDs.

    What techniques can I use to display the relationship of manger and to his staff? Then if the staff are managers display their staff in turn. I have five layers of management in my organisation.

    Any advice would be appreciated. Thanks for any answers.

    Viewing 0 reply threads
    Author
    Replies
    • #529211

      I haven’t used it myself, but it sounds like the Treeview control would do what you want. It is an ActiveX control that is on the “More Controls” button on the toolbox.

    Viewing 0 reply threads
    Reply To: Management structure / family trees

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: