AnsweredAssumed Answered

Table Relationship Question - Join Table

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

Hello,

 

So I'm working my way through learning Filemaker and I am creating a Gradebook. I have set up the following tables:

 

Class

Assignments

Students

Lectures

 

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.

 

Geoff

Outcomes