Instead of 140 fields, you should probably have a separate table for the questions. Actually a table for the Questions and a Response table for a particular's user's questions / answers. The Questions table would have the logic for the validation. A new Questionaire script would generate records in the Response table based on the Questions table.
Thanks David. That sounds really interesting. The way I understand it the question table will have 140 records as opposed to 140 fields in one record. Each question record will have one field for the actual question. There will probably be some kind of an ID field to link all these questions to one questionnaire. When a user is asked to complete a questionnaire, 140 response records will be created with the related question showing up as a label next to the response field. Somehow all of these fields and labels (questions) will have to be displayed on a coherent layout. How would the validation logic work on the question table? Especially when one question will determine the response to any number of answers.
Do I sort of have the idea?