Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2008
    Posts
    4

    Unanswered: Question And Answers

    Hi Guys,

    i am developing a application where i need to save answers for multiple users.
    it would be much like a security question and answer type.
    i have many users where every one need to fill a form . so each user will be given with different types of forms.so when a user fill the form then it should be saved in database.

    i want help in developing the database as how to develop with a database tables with different types of questions and answers.


    thanks in advance guys for any help

    thank u,
    jagadesh.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    what do you have so far?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Oct 2008
    Posts
    4
    I Just have The Users table . iam developing the application from scratch . i want how can i store both questions and all well as the answers of a perticular user.

    thank u,
    jagadesh.

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    i think you will find that more people here are willing to help you with someting than do it for you.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    There are a number of ways of doing it

    This is a Copy of My Setup

    Question Table
    ===========
    QuestionID
    GroupID
    QuestionToAsk
    AskQuestion true/false
    ...
    ....

    Answer
    ======
    AnswerID
    UserID
    QuestionID
    Answer <= what was answered
    Comments <= user coments about the question

    User
    ====
    UserID
    ...
    ...
    ...
    STPFQ = ture/false =SelectThisPersonForQuestioning

    the admin person can select User
    the Admin person select which Question tobe asked

    I have a Make Table the Select all the question to be asked
    and make the answer table

    then It build a Execl File for each user with the Question in it
    them it send out the excel file to the User
    they open answer all the question and send it back
    (the excel file has hidden colouns in it that hold the AnswerID)
    when the excel files comes back my program read the excel file put
    answer into the database base on the hidden answerID then then the report
    are created
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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