Parent Child Data

Need help Database
1

Hi
I have a list of programs that people might run
Eg
Leadership
Communication

and then I want to list the topics under these

Eg
Leadership
Team goal setting for managers
topics 2
topic 3 and so on

communications
Difficult Conversations
Engaging stakeholders

I wasn to to be able to show the top level headings and the topics underneath all in one big list.

I thought of using a parent child relationship of category and topic but I am not sure how to link this in option sets.

2

Hi there, @kylie… one way to go about doing what you have described is to have an option set for programs and an option set for topics. Then, in the topics option set, create a new attribute, and link that attribute to the programs option set. At that point, every topic can have a relationship to its associated program, and showing the lists you described should be easy.

Hope this helps.

Best…
Mike

3

Thanks so much

1 Like