Organisation chart

J

Jim Tanis

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????
 
D

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?
 
Top