Qrew LegendWell, the best design would be to have a table with a list of standard campaign questions, possibly group with tags in a multi select field.
Then, when you create a survey record either by a pipeline or an a button push, you could import the standard survey questions into the particular survey you just initiated. That way you can control which questions are associated with a survey and they could be selected from a library of Choices.
I am ok with creating a table to house question and/or response options but i dont want the users to have to create a child record per question, ideally I am looking to have
The Users would only have to create child records for the unique or custom questions. A Pipeline should auto build the records from the Standard table to the questionnaire table for the particular campaign. I have used the technique Mark has described for multiple business cases.
