Managing a Questionnaire

[JanB]

I'm writing an application to track health history for athletes.

Essentially each student fills out an on-line health questionaire to which they answer yes or no to each question. If yes, they fill in the details. There are 90 questions on the current questionnaire but it needs to be modifiable by an administrator.

I only want to retain the "yes" information for that student.

So far i have a Student table and related Health History table. How should i set up the Questionnaire table so as to avoid lengthy scripts?