Link to home
Start Free TrialLog in
Avatar of Swn-Y-Mor
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?
ASKER CERTIFIED SOLUTION
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Swn-Y-Mor
Swn-Y-Mor

ASKER

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!
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.
Not abandoned, I'm still working with the suggestions