I'm building an app that will display three sets of information based on the value of a pick list. It'll display the Definition of the value, a list of activities (Text not objects) to complete and a list of Evidence.
The definition, activities, and evidence will likely change as values are added, remove or things just change normally.
So I'm building a "settings" option within the App. What I want to do is to be able to pull from a query or custom objects what the definition, activities list, and evidence list are for the provided value.
Which would be better for this? Custom settings or an Object?
I was going to the custom settings route, but there's no "Related" option in custom settings. You can't have a "Name" of a CS duplicated within the set. So if I want to pull everything for the value of "Test Me" I couldn't reference a single setting.
A text area on the custom settings wouldn't provide enough flexibility.
An object would allow me to create a "Pick List value" record and related "Evidence" and "Activities" for nice SoQL - but I run the risk of this getting exposed to the end user.
What's the best method for my use case? Am I missing a option for Custom Settings that would give me the List capability for a single value?