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.

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.

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...

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: