Microsoft, MS Access, 2003, collect survey responses via form
Posted on 2007-08-06
I am collecting survey responses, and would like to do it via form. I have a table (tblSurvey) with SurveyID (PK), Name, and SurveyDate and a separate table (tblSurveyDetail) with SurveyID (FK), QuestionID, QuestionsResponse. The challenge is, the form should list all the questions (they are already predetermined), and the user would just enter in the responses. I am not sure how to move the question list with response to the tblSuveyDetail for each response without forcing the user to select row-by-row the question and corresponding response. The alternative, is to create a separate field for each question response, but I realize that is not acceptable.