Newbie question-showing related subtopics


#1

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?


#2

You will probably want to look into the concept of “Lookup Fields”


#3

Yep. That did it. Thanks!