Simple one question survey form

Posted on 2006-03-26
Last Modified: 2010-04-25
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?
Question by:Swn-Y-Mor
    LVL 70

    Accepted Solution

    Hi Swn-Y-Mor (gaelic?),

    There will be two different tables for this:

    Table 1: Questions

    QuestionID (primary, autoincrement)

    Table 2: Answers

    AnswerID (primary, autoincrement)

    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.

    Author Comment

    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!
    LVL 70

    Expert Comment

    by:Jason C. Levine
    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.

    Author Comment

    Not abandoned, I'm still working with the suggestions

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
    This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now