How can I write form field data into rows rather than columns?
Posted on 2006-03-23
I am trying to create a simple online questionnaire, using frontpage 2003, to go on our intranet. The idea is to use it for entering workshop evaluation data (happy sheets filled in by our client delegates at the end of an event) and automate the process of reporting on this data.
So for instance, Question 1 might read: 'To what extent were the workshop objectvives met?', below this there is a dropdown box (1-5) rating and a txt box for entering any comments. Question 2 might say: 'What benefits have you personally derived?' and just have a txt box to enter the delegates comments, and so on and so on.
My form is setup and connected to my access db but I only appear to have the option of writing form fields into columns. What I want is for each question (rating and comment response) to go into a seperate row in the db. I suspect that I need to insert some kind of looping code for this to happen but its a bit beyond me at the moment - any pointers or sample code gratefully received as I'm completely stumped!
Many thanks in advance,