Jump to content
Sign in to follow this  
Kurt Knippel

Mulit Finds

Recommended Posts

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

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.