Need help creating an on-line health questionnaire

[JanB]

Hello all. Have learned much from these forums but now have a problem I can't seem to resolve.

The applictaion is conceptually simple. I need to keep track of a student-athletes health history for a university's Sports Medicine dept.

In August, a student fills out a 90 question Yes/No form relating to their health history (e.g.Have you ever had a knee injury? If so define dates and details. )

I would like to present the student with a set of layouts containing multiple questions, but only save the question and the comment for the "yes" answers.

I have 3 tables

Student table (wtih demographic info)

Health history table (which contains the question and comment)

Questionnalire table (the questions)

The Student -> Health history relationship - no problem.

My question is

1 how would I relate the questionnaire table to this TOG?

2 how would i set up a 'simple' script to log only the "Yes" responses?

Many thanks in advance.

[bruceR]

3. What are your data privacy requirements and how will you meet them?

[JanB]

excellent question Bruce - and I haven't worked out the authorizations yet.

For the moment we are looking to install FM 7 Server within the Sports Med dept only. The scenario is that the students fill out a paper form at home. When they come for thier yearly physicals they will input the data within the facility.

In the future, they'd like to make it a web-based apllication.