Forums
This topic is locked
SQL 7.0
Posted 18 Sep 2001 15:00:18
1
has voted
18 Sep 2001 15:00:18 Dwayne Miller posted:
I'm building a database to hold questions and answers for a questionnaire, and I need to know how to set up the table so that the questions and answers are linked correctly. When I display the questions with the answers after it has been completed, I want the right answers to display with the right questions. I have created QueID and AnsID columns, as well as QueTxt and AnsTxt columns, but I can't get the insert record behavior to load the answers into the AnsTxt column, because all the entries in my form are named something related to the question. Should I name the responses Ans1, Ans2, Ans3, etc., and do I have to create a column for every possible answer?Thanks