So, either I'm searching for a plugin or I'll try to develop one for this purpose but I can't seem to find anything applicable. Perhaps I wasn't searching with the correct terms.
What I have setup is something like this: there are 3 types of posts/pages that I want to relate to one another. Lets say I have a baseball player as a post. That player has an agent and a team they play for. When I go to their edit-post area in the Wordpress admin I want to be able to have a drop-down list that allows the admin to choose who their agent is from a pool of all agent's in the system. A similar drop down would let you designate what team they play for from a pool of all teams in the system.
In addition to this, each team and each agent would have the same functionality. As an admin, you would be able to inter-relate each type of post (player/team/agent) using a similar method.
Basically, it would look in the database for all of the posts with the category "player", "team" and "agent", then let you link them together, either once or multiple instances for a post so that when you go to the players page, you can find out their agent's info and their team info, all with the ability to go to the agent's post or team post as well.
Any idea if something exists or what I may be looking for?