asked on

MS ACCESS - Polulate Organizational Structure based on employee positionand location

Hi,

I want to auto populate a company organizational structure, based on 2 fields called, position and location. For example

I have a President and Vice President, on the top of the organizational structure, this then branches off into 4 locations, each of which have managers, below the Vice President, and employees beneath them.

Right now, I have a Excel Doc that shows this, but maintaining this is a hassle. I want Access to hold this info, and auto generate the the organizational chart.

So, Pres
|
Vice-President
| | | |
Manager Manager Manager Manager
| | | |
Employees Employees Employees Employees

Any suggestions?

Scott McDaniel (EE MVE )

You'd need to store your data in a relational fashion, of course.

tEmployees
-----------------
lEmployeeID (AutoNumber, PrimaryKey)
sEmpFirstName
sEmpLastName
lEmpType
lManagerID
etc etc

tEmployeeType
-------------------
lEmpTypeID (AN, PK)
sEmpType

tEmployeeType would contain items such as Employee, Manager, Vice President, etc.

You would then store the "manager" for each employee with that record. From there, you could use several different methods to create your hiearchal tree (but Access doesn't have any builtin "tree" mechanisms).

jfer0x01

ASKER

Any other Office Products?

Perhaps VISIO, Project or an Excel Function?

Jim P.

Don't hold me to this, but I think Vizio can do a front-end to an Access db to build such a tree.

Scott McDaniel (EE MVE )

Visio can interact with Access, but like Jim said, I'm not sure that if could work tightly enough with Vizio to do what you're after. Visio is VBA-enabled, so you could possibly automate it, but I've never done so (and don't know anyone who has).

You could fudge this in Access with listboxes and such ... I've done something similar a looong while back, and while it was somewhat crude it accomplished what was needed and the client was happy with it. It looked a lot like the Relationship diagram in Access, but wasn't interactive (i.e. you couldn't move the listboxes and such around).

ASKER CERTIFIED SOLUTION

Markus Fischer

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jfer0x01

ASKER

Ill Stew on this for a while.

Scott McDaniel (EE MVE )

Thanks. We'll await your response.