AnsweredAssumed Answered

Table Relationship Question - Join Table

Question asked by gswest on May 14, 2017
Latest reply on May 15, 2017 by coherentkris



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.