Kurt Knippel Posted February 27, 2001 Share 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:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
LiveOak Posted February 28, 2001 Share 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 Link to comment Share on other sites More sharing options...
longncsu Posted February 28, 2001 Share 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? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7759 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now