A
Alex
I have one question (at bottom of post) and have included
table structure and form structure.
My table structure is:
tblRegistration: registration id; cient id (FK); course id
(FK)
tblTestMaster: testmaster id; testname
tblTest: test id; registration id (FK); attempt date;
testmaster id (FK)
tblQuestions: question id; question; testmaster id (FK)
tblAnswers: answer id; question id(FK); answer; test id
(FK)
I have a form which pulls up those students registered in
a defined course.
First subform has tblTest info (linked master/child to
registration form by registration Id).
Second subform lists the questions and answers. This is
not linked (master/child) to the first subform since I
want all the questions to show up, not just those which
already have answers entered against them (for specific
test id)
The problem:
Because Questions and Answers tables have to be linked in
a query in order to make a single subform of them, if
there is data in answers (against specific question id),
then that is the data that shows up in the subform,
regardless of the test id. therefore, I end up editing
pre-existing data instead of having a subform which has
questions and blank answer fields.
Is there a way to get around this?
Please help,
alex
table structure and form structure.
My table structure is:
tblRegistration: registration id; cient id (FK); course id
(FK)
tblTestMaster: testmaster id; testname
tblTest: test id; registration id (FK); attempt date;
testmaster id (FK)
tblQuestions: question id; question; testmaster id (FK)
tblAnswers: answer id; question id(FK); answer; test id
(FK)
I have a form which pulls up those students registered in
a defined course.
First subform has tblTest info (linked master/child to
registration form by registration Id).
Second subform lists the questions and answers. This is
not linked (master/child) to the first subform since I
want all the questions to show up, not just those which
already have answers entered against them (for specific
test id)
The problem:
Because Questions and Answers tables have to be linked in
a query in order to make a single subform of them, if
there is data in answers (against specific question id),
then that is the data that shows up in the subform,
regardless of the test id. therefore, I end up editing
pre-existing data instead of having a subform which has
questions and blank answer fields.
Is there a way to get around this?
Please help,
alex