How can I display a hierarchal relationship in a report?

  • Thread starter Thread starter David Frick
  • Start date Start date
D

David Frick

How can I display a hierarchal relationship in an Access report?

I have an employees table with an EmployeeID and a ReportsToID. The
ReportsToID contains the EmployeeID of the manager that the employee reports
to. So the table looks something like this:

EmployeeID Name ReportsToID
1 Bill NULL
2 Dave 1
3 Sue 1
4 Sally 2
5 Jim 3
6 John 3

I want the report to display as:

Bill
Dave
Sue

Dave
Sally

Sue
Jim
John

Does anyone have any idea how to create such a report?
 
David
Create a report based on Employees
add a subreport also based on Employees
in the subforms's properties:
Link Child Fields : ReportsToID
Link Master Fields: EmployeeID

Ta da!

HS
 
Thanks !!


HSalim said:
David
Create a report based on Employees
add a subreport also based on Employees
in the subforms's properties:
Link Child Fields : ReportsToID
Link Master Fields: EmployeeID

Ta da!

HS
Click to expand...
 
Back
Top