I'm a producer, and I working on a way to track stories we are developing. I want to be able to keep track of the different stories, where we submit them, and if they are bought. The part which is confusing me is on both the Story pages, and the contact pages I want to keep track of ownership.
For example, I put myself, and a partner in the Contacts table. I also have a table for Stories, and Deals.
On the Story layout I want to show what Contacts, and the percent of the story they each own. If I go to a story record I can see what Contacts own it, and what percent they each own.
I also want to be able to go to the Contacts layout, and see all the different stories they own, and what percent.
You can go to each contact record and see...
5% of a Story called "Bladerunner"
10% of a Story called "Bambi"
10% of a Story called "Beauty and the Beast"
20% of a Story called "Bambi"
If I go to the Story Record I see...
Eric owns 5%
Eric owns 10%
Joe owns 20%
Beauty and the Beast
Joe owns 10%
I'm not sure what Tables I need, and how to create a relationship to get this information to show on each record.