Hi,
I am putting together a student record system. I have a student table and a subform which displays info from another table showing what modules they are taking - every student record displays the two or three relevant modules.
I also have a separate module information form that shows for each single module, the list of students enrolled, the room number etc.
I would like to be able to click any of the two or three modules a single student is taking (in that student's subform) and to be taken to whichever relevant module I've clicked (in the relevant module information form), to see all the students, the room etc for that particular module.
I'm amazed I've got this far. Is there an easy way to describe how I might do this next step?
Thanks,
Adam