Question about tables

Hello,

I wil introduce myself i am a dutch student. At the moment i am working on a database but i ran into a problem that i can't get my head around.

Lets say i have 3 tables

Table 1 : Has students in it

Table 2 : Has their groups

Table 3 : Has their classes they follow.



Now i want i want to create a query. Which connects a student with a group and then shows me all the classes he has to attend to.

So lets say i have a search form (which i created) i search for the student (i can get this far) then i want it to show me the groups he/she is in and to show me the classes he/she follows per group.



Thanks in advance and sorry for my bad english:rolleyes:

Question about tables