I am setting up a survey web site where one group of people can create survey questions and then select which questions to put on their survey. I want to be able to show all of their questions on one page with check boxes (already done) and then submit all of the questions they selected to the survey table. So there would be one record submitted for every question they select
The survey table is named surveytbl and it has the following fields: sid (survey id an autonumber field), surveyname, questid (question ID), deptid (department ID), surveydate. I use #database# to dynamicaly identify my database.
I also want to do the same thing when people fill out the survey it will show all the questions for the survey on one page but when the questions get answered each answer will get put into a table with the question ID, the user ID, the survey ID and of course the answer.