Swn-Y-Mor
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Not abandoned, I'm still working with the suggestions
ASKER
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!