Hi,
I've been puzzling over how to connect these tables on Filemaker for hours, and hopefully someone can point me in the right direction.
I'm trying to connect the tables in such a way that when I select a student, and a specific course, I will get all of the marks belonging to that student for the selected course.
So far, all I've been able to do is either get one of the marks for the student (instead of all of them for the chosen course), or a set of marks for some random student that was not selected.
It's gotten to the point where I'm just doing trial and error to connect the tables since any logical connection doesn't seem to work.
I've attached the tables in this post.
Any help would be greatly appreciated!
