Form for retrieving related records
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's the database. What will you use to develop the application/front end/website?
ASKER
I was able to get it to work. Thanks, Camilla.
Here's what I did:
I created a blank form, then added a combo box that the row source as the student table. I then used the Insert SubForm query wizard to add a box for the attendance. It automatically asked which field linked the two. Thanks, again.
Here's what I did:
I created a blank form, then added a combo box that the row source as the student table. I then used the Insert SubForm query wizard to add a box for the attendance. It automatically asked which field linked the two. Thanks, again.
ASKER