Desmond_Fox
Registered User.
- Local time
- Tomorrow, 02:40
- Joined
- Dec 3, 2014
- Messages
- 12
Hi,
I've been struggling with this challenge for a week.
I have a primary school database. I'm trying to create a form that allows a teacher to select their class, then select a subject and then be presented with a data entry form in a table layout that lists only their student's names in one column and an empty column to input results for the selected subject.
To simplify my explanation to just three tables, lets say my tables are:
> Students....which stores student names plus a foreign key for their class
> Classes...which stores the class name
> Results...which stores all the results (fields are: ResultID (key), StudentID, SubjectID, Result, DateofResult)
I have no problems creating reports where the teacher selects their class from a combo box to generate a report based on a crosstab query. But this one has me stumped.
Any pointers in the right direction would be gratefully received (even the terminology used for this sort of thing would be a help so I can do better research).
Thanks
Des
I've been struggling with this challenge for a week.
I have a primary school database. I'm trying to create a form that allows a teacher to select their class, then select a subject and then be presented with a data entry form in a table layout that lists only their student's names in one column and an empty column to input results for the selected subject.
To simplify my explanation to just three tables, lets say my tables are:
> Students....which stores student names plus a foreign key for their class
> Classes...which stores the class name
> Results...which stores all the results (fields are: ResultID (key), StudentID, SubjectID, Result, DateofResult)
I have no problems creating reports where the teacher selects their class from a combo box to generate a report based on a crosstab query. But this one has me stumped.
Any pointers in the right direction would be gratefully received (even the terminology used for this sort of thing would be a help so I can do better research).
Thanks
Des