you need 3 tables.
When you create a new record in Questionnaire, you pick the questions to be answered from Questions, creating lineitems in QuestionnaireQuestions, a table that has 4 fields: PK, FKQuestionnaire, FKQuestion and Answer.
Sorry, I was not clear enough. In the questionnaire table I may have as many as 30 standard questions, all of which I need to create a new set of empty fields. On occasions I may want to add a question to the "template" table, but I always want to transfer all 30+ questions to create the new record.
One thing I have tried was creating a "template" file and then creating a script to import that records into the "live" file.
I am try do do it using just one file and not using some form of loop script.