Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Management structure / family trees

    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.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Management structure / family trees

    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.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Management structure / family trees

    There

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Management structure / family trees

    There

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •