Showing Teachers in a Class type repeating group

Need help Database
1

Hello,

I have 3 main tables :

  • Classes
  • Subjects
  • Teachers

Teachers are related to Classes via the Subjects they teach.

Important : Many Teachers can teach Many Subjects and Many Subjects can be taught to Classes.

Hence I have 2 junction tables :

  • Between Classes & Subjects
  • Between Subjects & Teachers

How can I show Teacher name in a Classes Type repeating group ?

2

Generate a list of subjectEntries of a teacher or teachers. Then build an expression where you look for your classes’ subject to be in (“is in”) that list of subjectEntries.

This will allow you to access that subject’s teacher’s name.