I am trying to produce a re****t which is an exam. The data structure
seemed fairly simple with only two table (in access) designed as
follows, where* denotes a primary key:
TQuestion (QuestionID*, QuestionNum...etc)
TQuesionPart (QuestionID*, Number*, Letter*, Question, Answer...etc)
To display these on a quickre****t i need the structure
QuestionID1
..................................................
Letter1 Numeral1
Numeral2
Numeral3
Letter2 Numeral1
Letter3 Numeral1
QuestionID2
..................................................
Letter1 Numeral1
Letter1 Numeral1
etc.etc.
So my re****t structure is currently:
Title
GroupHead1 //Question info grouped by QuestionID
GroupHead2 //QuestionPart Ino Grouped by... QuestionID?
Detail // Letters + Numerals of this question
GroupFoot1
GroupFoot2
PageFoot
However i can only get this to preview for either:
a) a single question, with all parts or
b) each question with only a single part each
depending on which query i set to 'master' of the re****t.
The two queries are fairly simple so i don't think they need to be
posted. i think there is something fundamentally wrong with my
concept. ideally i could go back and restructure the data, but this
project is too far along at this stage.
Sorry for all this detail, i have spent several hours on this problem
and would love some advice =)
thanks in advance.
|
