quote:

---

Originally posted by longncsu:

I have 2 tables, one table holds all the Exec. Managers and the people they manage (Managers). The second table holds all the Managers and the people they manage (Supervisors). Is there a way to put all 3 fields in one table or a way to copy the results from the first find and use it in the second find?

---

The best way to do this is with two fields only. The first field says who you are, the second field says who your boss is.

You can then create self-relationships to get the entire organization overview.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

The cap'n is on the nose, this is a classic example of a linked list structure. If you still have an old copy of Claris Impact, you can even use the data draw feature to create an organization chart for you!. -bd

I have 2 tables, one table holds all the Exec. Managers and the people they manage (Managers). The second table holds all the Managers and the people they manage (Supervisors). Is there a way to put all 3 fields in one table or a way to copy the results from the first find and use it in the second find?