Organisation chart

[Guest]

I have set up a table of employees with 2 fields. Name and ResponsibilityID,
data types text and number. each employee is given a responsibility ID from
another related table Responsibilities like:

1 -> general manager
2 -> local managers (subordinate to general manager)
3 -> empoyees (suordinate to local manager)

How can I make a report with an organisation chart like look, which places
the records at a level of responsibility according to the ResponsibilityID
value????

 

[Duane Hookom]

Some versions of Visio (and possibly other software) have the capability of
creating Org charts from database tables. With only two fields, how do you
know who reports to whom?

 

[PC Datasheet]

Contact me if you would like my help.