Kurt Knippel 0 Posted February 27, 2001 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:FmPro@home.com http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Quote Share this post Link to post Share on other sites
LiveOak 1 Posted February 28, 2001 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 Quote Share this post Link to post Share on other sites
longncsu 0 Posted February 28, 2001 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? Quote Share this post Link to post Share on other sites
