Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Brampton, Ontario, Canada
    Posts
    27

    Unanswered: Contest Entry Form

    Contest entry Form
    I am designing an Access DB to collect responses to Questions in a contest entry form.
    i.e.

    Content Entrant Name, Address, etc...
    QUESTION ----- RESPONSE
    Question 1 ----- A or B or C
    Question 2 ----- A or B
    Question 3 ----- A &/or B &/or C &/or D
    Question 4 ----- A or B or C or Other_________
    Some questions will allow the entrant to select more than one response
    as in Question 3
    Some Questions will require the entrant to write in a response as in Question 4

    I currently have 3 Tables
    ENTRANT QUESTIONS RESPONSE
    But I"m not sure this is the proper design because I can't get a form to dispaly all the questions with all the respective potential responses.
    This seems like a simple design but is in fact rather perplexing.
    Can someone offer some advice.
    Regards
    Brad

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    perhaps:

    tblAnswers:
    - entrantID long (lookup on tblEntrant)
    - q1a yes/no
    - q1b yes/no
    - q1c yes/no
    - q2a yes/no
    - q2b yes/no
    - q3a yes/no
    - q3b yes/no
    - q3c yes/no
    - q4a yes/no
    - q4b yes/no
    - q4c yes/no
    - q4o text
    - etc

    ??

    izy

Posting Permissions

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