I created a database to manage my students. I created a query from this table as a lookup for the students' names, which also retrieves the Student ID. I have a separate table for tracking attendance. This table includes the student ID and date/time of the class only. I'd like to create a form that:
has a drop-down box to select the student
then, using the student, ID, shows (in a subform) all of the classes that student has attended.