By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,934 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,934 IT Pros & Developers. It's quick & easy.

Survey - storing multiple choice and free-form text

P: 1
I've been asked to build a survey database. The survey is to be dynamic, allowing any number of questions to be part of the current survey. So I've got a Survey table with SurveyDetail, and a Questions table with a column named 'Active' for that purpose. This makes storing answers a bit difficult. Some are multiple choice, in which case it's as simple as storing an AnswerID in SurveyDetail that links to a Answer table that links to the Question table. But I'm stumped as to how to store free form text. The only solution I've been able to come up with is to store both AnswerID and Answer (text field) in SurveyDetail, allowing both to be NULL and outer joining to the Answer table. This is obviously not the best solution. I'm sure there is a more elegant way of doing this. I hope I've made myself clear, any help is appreciated. Thanks!
Feb 27 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,471
I'm getting some of what you're saying, and it's clear you're not here to learn any basic concepts, but I'm not really getting precisely what your problem is. From the wording of your question I'm sure you'll understand why that's important, coming from the other side of a web page.
Feb 28 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.