I want to create a program evaluation/ logic model database structured as follows:
Event
- Activities
-Short-term outcome
-long-term outcome
-Strategic Plan Goal
Then, if the event includes an activity, it would automatically show that it includes the outcomes and goals associated with that activity. Does that make sense? Is that possible?
So far, if I go to the events, I can see the linked activities, but how do I get it to pull over strategic goals that are associated with that activity?