D
dee
Hi,
I have a database in which some of the tables are already populated:
tblQuestionnaires
qstnaireID (PK)
qstnaireName
tblQuestions
qstID (PK)
qstnaireID (FK)
qstnNo
qstnText
tblAnswers
answerID (PK)
qstnID (FK)
I now wish to create a form that will allow me to display/select
questionnaires, input in the corresponding respondent data and the responses
of each respondent
answer, with the question number and text displayed on the form as well.
The tables that I wish to populate via the form are:
tblRespondents
respondentID (PK)
qstnaireID (FK)
responseDateTime
interviewLang
tblResponses
respondentID (PK and FK)
qstnID (PK and FK)
response
I have no problem with the main form that displays the questionnaire ID and
Name and its subform that contains the respondentID, qstnaireID, date/time,
language. These are linked master/child via qstnaireID.
My problem is the 2nd subform. I have tried every which way and can't
figure out how to accomplish having a form that displays the question number
and text, with the respondentID in the subform1 displayed (linked), and the
ability to use a combo box to select the appropriate answer. (The combo
record source is tblAnswers)
Even when I finally manage to display all of this, as soon as I select an
answer and try to move to the next question, I get the message that a
corresponding record is required in the tblRespondents.
Any help would be very, very appreciated.
I have a database in which some of the tables are already populated:
tblQuestionnaires
qstnaireID (PK)
qstnaireName
tblQuestions
qstID (PK)
qstnaireID (FK)
qstnNo
qstnText
tblAnswers
answerID (PK)
qstnID (FK)
I now wish to create a form that will allow me to display/select
questionnaires, input in the corresponding respondent data and the responses
of each respondent
answer, with the question number and text displayed on the form as well.
The tables that I wish to populate via the form are:
tblRespondents
respondentID (PK)
qstnaireID (FK)
responseDateTime
interviewLang
tblResponses
respondentID (PK and FK)
qstnID (PK and FK)
response
I have no problem with the main form that displays the questionnaire ID and
Name and its subform that contains the respondentID, qstnaireID, date/time,
language. These are linked master/child via qstnaireID.
My problem is the 2nd subform. I have tried every which way and can't
figure out how to accomplish having a form that displays the question number
and text, with the respondentID in the subform1 displayed (linked), and the
ability to use a combo box to select the appropriate answer. (The combo
record source is tblAnswers)
Even when I finally manage to display all of this, as soon as I select an
answer and try to move to the next question, I get the message that a
corresponding record is required in the tblRespondents.
Any help would be very, very appreciated.