I figured it out to add another table for the subquestions responses, "other":
tblPart3Other
Part3OtherID - PK
ApplicantResponseID (FK)and PK
AppliantOtherAnswer-Text field
I have a small questionnaire of our paper aplication that I have in my DB. I have set up tables for the questions, the responses and also the responses to the subquestions to some of the questions. Some of the responses to the subquestions are "other". If it is other, i need to set up another...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.