Create a Layout where I can enter data for multiple tables
I need to create a layout where I can enter data for multiple tables. Looking at my screen shot, I currently have one table labeled "Opportunity" which then splits into several one to one tables based on the type of opportunitiy.
I want to be able to enter data into one layout, and have it entered into the multiple one to one tables.
For example, I want to enter a new opportunity that is an Event. On the layout I should be able to type in Opportunity ID (only once), Opportunity Date, Opportunity Type (Event), EventLocation, EventType, Event Description, EventGoals, EventOutcomes. This data should then automatically fill the Opportunity Table and the Events Table.
In the same layout I will also want to enter a new opportunity that is an Experience. So on the layout Is hould be able to type in Opportunity ID, Opportunity Date, Opportunity TYpe (Experience), Experience Type, ExperienceLocation,Experience Description. This data should then automatically fill the Opportunity Table and the Experience Table.
Where I am getting confused is I do not know how to automatically fill the Events, Experience etc. tables because every Opportunity ID will not go in all the sub tables- it depends on which type (events, experience, learning op, etc) it is.
Does this make sense?