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.