Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Associating new data to existing data (FP 2002)

    I am looking for a way that I can query database
    information and then add comments about the data that was
    displayed using forms. I currently use forms to collect
    survey information from my students. Now I want to be
    able to click a button that allows me to comment on the
    survey questions. The problem I run into is the
    association between my comment and the survey question.
    I can't figure out how to relate the two items so I can
    refer back to which question I made comments. In other
    words, I want my comment about student A, question 1 to
    refer back to question 1 from student A. I am also
    looking for the ability to allow multiple people to make
    comments and have an e-mail get passed to the next person
    in line once comments have been made. It would look like
    this;

    Student answers questions using my form and that
    information is stored in the database

    I review the answers and make comments about a particular
    question(s)

    A notice gets sent to the next person in the chain of
    command letting him know that I have completed my review
    and my comments have been done.

    That person can then go and review the original questions
    seeing my comments with the associated question and make
    his own comments if required.

    Thanks...

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Associating new data to existing data (FP 2002)

    What are the fields in your database that identify Student A and Question 1? Although it is perhaps considered bad form by database gurus, you could create a second table that requires a match on both of those fields to link a comment to a student and question.

  3. #3
    New Lounger
    Join Date
    Sep 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Associating new data to existing data (FP 2002)

    Thanks for responding.

    The problem I have is when I try to query the data, i can not use the queried data to submit. I insert a button on the comment form. When I click the button, it opens another form allowing me to submit data. In the second form, I can use a query to view the information about the data, but I can't link my comments to the original data. When I submit my comments, it goes into a seperate table without any association to the original data. I need a way to link my comments back to the original data. Thanks again...

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Associating new data to existing data (FP 2002)

    > When I click the button, it opens another form allowing me to submit data.

    The way I would do this is to have some hidden fields that pass the relevant linking fields to the second form. Are you writing the code yourself or using the newest DB wizard? I haven't used the database components in a couple of years, and haven't used 2002's at all, so all I can tell you is that it should be possible. Let me describe the scenario in ASP-think:

    Main results page as received by client:

    Student A
    Question 1
    blah blah blah
    Comments:
    None
    <form action="add_comment.asp">
    <input type="hidden" name="stud" value="A">
    <input type="hidden" name="ques" value="1">
    <input type="submit" value="Add Comment">
    </form>

    Main results page on server:

    Student <%=objRS("Student").Value%>
    Question <%=objRS("Question").Value%>
    blah blah blah
    Comments:
    'Code to query comments table and insert results here, or None if nothing is found
    <form action="add_comment.asp">
    <input type="hidden" name="stud" value="<%=objRS("Student").Value%>">
    <input type="hidden" name="ques" value="<%=objRS("Question").Value%>">
    <input type="submit" value="Add Comment">
    </form>

    Does this help?

Posting Permissions

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