Organisation chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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