So I'm working my way through learning Filemaker and I am creating a Gradebook. I have set up the following tables:
I want to be able to set up a list of Assignments in my Classes Table by using a Portal to Assignments.
I a then want to add students to a class via another portal.
My problem is this...I want students to have a portal that shows the assignments they have for a class.
So I can't connect Class and Assignments, Class and Students, and Students and Assignments. I tried adding another Table - StudentAssignments but it can't be connected to both Assignments and Students. I'm stuck as to how to fix this. I have parent keys for all tables and foreign keys for Students and Assignments as well as Lectures.
Any help on this would be greatly appreciated.