Org Chart with Relational DB - how???

M

Minion

hi there,
please bear with me - I'm neither a Visio or DB expert in any way shape or
form...
ok, this is where I'm at, ran the org chart wizard and generated said org
chart from ODBC DB.
the thing is, it is a relational DB
I've got info in two related tables in Access -
dbo_Employee and dbo_Employee_Position
how can I display fields from both [not just one] of the
tables?
ie: First_Name and Surname from dbo_Employee
and
Job_Title from dbo_Employee_Position
Supervisor_Posn_ID give the hierarchy, and Person_ID is the unique
identifier in the dbo_Employee table.
would I be better to build this outside of the wizard - does this give me
more options?
any pointers you could give me would be really appreciated :)
kind regards
Jas
 
M

Markus S. Gallagher

It sounds to me, that you want to join the two tables together using SQL
along the following lines:

Select First_name, Surename, Job_Title from dbo_Employee,
dbo_Employee_Position where dbo_Employee.Person_ID =
dbo_Employee_Position.Person_ID
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top