I am working with a subform that tracks student scores for each item in a developmental inventory. Because I wanted to attach information to each item (age level), I set up the tables like this:
Items:
ItemID (e.g. DFM-01, DFM-02, etc.)
Item
DevAge
Scores:
AssessmentID
ItemID
Score
Assessments:
AssemmentID (autonum)
ChildID
ExaminerID
TestDate
Comments
Now I have created a form with a scores subform, and I would like all of the ItemIDs from the Items table to appear in that subform. I have tried to use an Append Query... this results in the ItemIDs being appended to the Scores Table with the AssessmentID (autonum) being set to 0, but not to the subform itself, which is where the data entry is being done. In effect, rather than choosing each ItemID from a pull-down menu, I would like the subform to automatically display all ItemIDs and then the data entry person would only need to update the scores for each student.
Any and all suggestions would be greatly appreciated! I hope I have been clear enough in my description.
Deidre
Items:
ItemID (e.g. DFM-01, DFM-02, etc.)
Item
DevAge
Scores:
AssessmentID
ItemID
Score
Assessments:
AssemmentID (autonum)
ChildID
ExaminerID
TestDate
Comments
Now I have created a form with a scores subform, and I would like all of the ItemIDs from the Items table to appear in that subform. I have tried to use an Append Query... this results in the ItemIDs being appended to the Scores Table with the AssessmentID (autonum) being set to 0, but not to the subform itself, which is where the data entry is being done. In effect, rather than choosing each ItemID from a pull-down menu, I would like the subform to automatically display all ItemIDs and then the data entry person would only need to update the scores for each student.
Any and all suggestions would be greatly appreciated! I hope I have been clear enough in my description.
Deidre