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
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