confused myself

Discussion in 'ASP .Net' started by leonaisse, Jan 9, 2007.

  1. leonaisse

    leonaisse Guest

    Hi All

    I need your help please, i've been thinking about this one for so long I
    have confused myself!

    I have a web app that contains a clients table in SQL server.

    When a new client is entered onto the system I want to take all the usual
    details(already complete) and on the next page I have 135 questions which
    could warrant a yes, no or not asked answer and store the answers to the 135
    questions in a DB table linked to the customer.

    What is the quickest way for me to code this page and the best DB structure
    to do this. I have the 135 questions in a DB table also.

    Thanks

    Leon
     
    leonaisse, Jan 9, 2007
    #1
    1. Advertisements

  2. If, and only if, you are sure there will only be 135 questions, you can code
    a single table with all 135 questions as different fields. As it is
    difficult to guarantee no further questions will ever be added, unless you
    are in 100% control, a better option is something like this

    Table 1 = Questions
    QuestionID
    QuestionText

    Table 2 = User_Question
    User_QuestionID
    QuestionID
    UserID
    AnswerText

    This allows you to alter the number of questions, esp. if the delivery of
    the questions is dynamic.

    --
    Gregory A. Beamer
    MVP; MCP: +I, SE, SD, DBA
    http://gregorybeamer.spaces.live.com

    ********************************************
    Think outside the box!
    ********************************************
    "leonaisse" <> wrote in message
    news:...
    > Hi All
    >
    > I need your help please, i've been thinking about this one for so long I
    > have confused myself!
    >
    > I have a web app that contains a clients table in SQL server.
    >
    > When a new client is entered onto the system I want to take all the usual
    > details(already complete) and on the next page I have 135 questions which
    > could warrant a yes, no or not asked answer and store the answers to the
    > 135 questions in a DB table linked to the customer.
    >
    > What is the quickest way for me to code this page and the best DB
    > structure to do this. I have the 135 questions in a DB table also.
    >
    > Thanks
    >
    > Leon
    >
     
    Cowboy \(Gregory A. Beamer\), Jan 9, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rob Meade
    Replies:
    4
    Views:
    510
    Rob Meade
    Dec 3, 2003
  2. newgenre
    Replies:
    1
    Views:
    388
    Kevin Spencer
    Apr 7, 2004
  3. =?Utf-8?B?V2lsbGlhbSBTdWxsaXZhbg==?=

    Please save me from shooting myself in the head!

    =?Utf-8?B?V2lsbGlhbSBTdWxsaXZhbg==?=, Oct 18, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    905
    =?Utf-8?B?V2lsbGlhbSBTdWxsaXZhbg==?=
    Oct 19, 2005
  4. Esco
    Replies:
    2
    Views:
    379
    Alex Hunsley
    Oct 2, 2004
  5. Joe Patrick

    Messages to Myself

    Joe Patrick, Aug 31, 2003, in forum: HTML
    Replies:
    6
    Views:
    830
    Joe Patrick
    Sep 3, 2003
  6. blar
    Replies:
    13
    Views:
    955
    Karl Core
    Dec 20, 2004
  7. JustSomeGuy

    I've painted myself into a corner!

    JustSomeGuy, Jun 22, 2004, in forum: C++
    Replies:
    4
    Views:
    513
    Dietmar Kuehl
    Jun 23, 2004
  8. Jon

    Getting myself confused

    Jon, Feb 13, 2007, in forum: ASP .Net Security
    Replies:
    0
    Views:
    209
Loading...