N
Niniel
I already asked this question yesterday, then thought I had solved it myself,
only to find out that I hadn't.
Bummer.
I have 3 tables - Activity, Questions and Answers.
Activity has the field ActivityID and some other fields. Questions has
QuestionID and Question. Answers has ActivityID, QuestionID and Answer. All
ID fields are number fields, the Answer field is a yes/no field.
Tables are linked 1-to-many between Activity and Answers, and 1-to-many
between Questions and Answers. In both cases, the join type is type 1.
The idea is to record in the Answers table how all the questions are
answered for each activity - yes or no.
I'm trying to create a query and form for this based on the Answers table,
but have failed to come up with a way that lists all the questions and
corresponding checkboxes, and then writes the values to the table.
I suspect I'm approaching this problem the wrong way, so I would be very
grateful for any advice that points me in the right direction.
Thanks.
only to find out that I hadn't.
Bummer.
I have 3 tables - Activity, Questions and Answers.
Activity has the field ActivityID and some other fields. Questions has
QuestionID and Question. Answers has ActivityID, QuestionID and Answer. All
ID fields are number fields, the Answer field is a yes/no field.
Tables are linked 1-to-many between Activity and Answers, and 1-to-many
between Questions and Answers. In both cases, the join type is type 1.
The idea is to record in the Answers table how all the questions are
answered for each activity - yes or no.
I'm trying to create a query and form for this based on the Answers table,
but have failed to come up with a way that lists all the questions and
corresponding checkboxes, and then writes the values to the table.
I suspect I'm approaching this problem the wrong way, so I would be very
grateful for any advice that points me in the right direction.
Thanks.