Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Questionnaire problem (2000)

    Hi,
    I have a bit of a problem with designing a questionnaire. At first glance I though it would be a simple project, on reflection............. <img src=/S/blowup.gif border=0 alt=blowup width=60 height=60>.
    I've had a look at <post#=337797>post 337797</post#> and the way I figure what I need to do is:

    TblArea - with AreaID, Area
    TblResponse - with ResponseID, AreaID, QuestionNo, Response
    TblQuestions - QuestionNumber, QuestionText

    The relationships would be ClientID linked to Client ID, QuestionNo linked to QuestionNumber. Enforced referential, delete casecade.

    The problem that I'm not too sure how to approach is the multiple responses. Some have true/false values, some have multiple choice, some have checkboxes, and so on. Also alot of them have the option of freetext, below the fixed answer. I guess that I need a TblResponse with QuestionNo and response text.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Questionnaire problem (2000)

    Designing and programming a complex survey is not easy. There is dedicated software for this - a Google search for survey software returns lots of hits.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Questionnaire problem (2000)

    Add a field for ResponseValue in your TblResponse. That will handle True/False and option group/radio button responses, plus numeric responses where the user might be indicating a value in a range. Use the Response field to hold free text and/or the text equivalent of the option choice, etc. That gives you the ability to display the questionnaire again as a form without translating the text back to numeric values in order to set option groups and check boxes.
    Charlotte

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Questionnaire problem (2000)

    What is the best way to link TblResponse to TblResponseText (the table with all the Question numbers in relation to the Answers)

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Questionnaire problem (2000)

    You've confused me. You called your table tblResponse in your first post. I was talking about adding another field to that same table to capture numeric values of *answers*, i.e., the -1 or 0 of a checkbox or the option value of an option group. What are you talking about?
    Charlotte

  6. #6
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Questionnaire problem (2000)

    Sorry.
    I'm not too sure how to deal with the limiting the users response to specific answers & how to relate them to the TblResponse, that holds the question number etc. Presumably this need to be done in a seperate table. Or can this be done with the data held in comboboxes on the form, thus returning one entry per answer?
    What I am trying to avoid are all the responses being displayed for all answers.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Questionnaire problem (2000)

    I don't understand the question. TblResponse holds the answers and it holds the question number. Do you mean how to relate a question and answer to a specific instance of a survery, i.e., the answers for Respondent #1?
    Charlotte

  8. #8
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Questionnaire problem (2000)

    I think the confusion lays at my end.
    With each response there must be a selection of specific answers to the question. So for instance, Q1 has Very Happy, Happy, Okay, Sad, Suicidal. I wish to display this as each reply having a check box, and the user selects just one entry, or altenatively a combo box with these listed and the user selects one entry.
    Where my confusion lies is presumably I need a list of responses allowed for each question somewhere in the database. My presumption is that TblResponse holds all the responses that have been given in relation to the questions, but doesn't actually list the responses allowed for each question, or am I off track on this one?

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Questionnaire problem (2000)

    To control this, you would use an option group with the button formatted as checkboxes. That will allow only one selection, and the option number selected is the value that would go into ResponseValue while you could still the associated text into the Response if you wished. The "allowed" responses are controlled by the option group. You are planning to create a form for this, right? To do this properly requires an unbound form with code for each control to write the value of the answer to a record in the TblResponse table.
    Charlotte

  10. #10
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Questionnaire problem (2000)

    That sounds like a lot of work!
    Presumably I could apply a similar thing used in <post#=363982>post 363982</post#>. This seems to be multiple questions running of a single form.
    Obviously it would need adapting to a degree, but I think it works quite well.

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Questionnaire problem (2000)

    There's no requirement to use the method I suggested. It depends on the complexity of the questionnaire and how you want to analyze the resulting responses. If the other method works for you, that's fine. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •