Simple one question survey form

I want to create a simple, one question survey form using Dreamweaver ASP pages, and Access database.
One question with three possible answers such as Yes, No, Maybe, selected by radio button.
The answers are anonymous, therefore no one need login.
I do, however, need an admin backend where someone can go in and change the question, and the three answers.
I am fairly comfortable using Dreamweaver and ASP, but it is the database design I am struggling with.
Any suggestions?
Swn-Y-MorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason C. LevineNo oneCommented:
Hi Swn-Y-Mor (gaelic?),

There will be two different tables for this:

Table 1: Questions

QuestionID (primary, autoincrement)
QuestionText
Answer1
Answer2
Answer3

Table 2: Answers

AnswerID (primary, autoincrement)
QuestionID
Answer

This allows you store past questions and their answers so you can pull things back up at any time.  If the survey is truly one and done, then your Admin just needs to be able to edit Questions and dump data/empty table from Answers.  If you want to store things, then the Admin needs to be able to insert new records to Questions and select Answers by QuestionID and dump the results of the query.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Swn-Y-MorAuthor Commented:
OK, I'm with you so far.
On my ASP page, I would need 2 recordsets. Can I have a page displaying dynamic text from Question Recordset, and also a form to submit answers to Answers Recordset?
Now you're beginning to see why I asked for help!
0
Jason C. LevineNo oneCommented:
Yes, you can do that without any problems.  The page would actually only have one recordset defined (Questions) and when you set up the form, just use the Insert Record behavior to send the answer to Answers.  No need to define a separate recordset for Answers unless you also want to display live survey results on the same page.
0
Swn-Y-MorAuthor Commented:
Not abandoned, I'm still working with the suggestions
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.