AnsweredAssumed Answered

Filtering based on (more than) many to many relationship

Question asked by mt_vernon on Feb 1, 2019
Latest reply on Feb 11, 2019 by beverly

Hello everyone,


I have set up a database with a many to many relationship:

"Different classes are taught in different cities on different months".


Below you will find the ERD.

Schermafbeelding 2019-02-01 om 10.18.54.png

From the layout of "Places" based on the table "Places" I create classes (that have a course and a month).

Schermafbeelding 2019-02-01 om 10.46.20.pngSchermafbeelding 2019-02-01 om 10.47.38.png

I want to see (on the Layout of "Places") on which months there are Classes for a Place. So I created a portal to "Months" with the field "Months". Now I see the correct months per Place.


Schermafbeelding 2019-02-01 om 10.58.26.pngSchermafbeelding 2019-02-01 om 11.00.28.png


But I want to click on a month and see the courses (in the list on the right) given on the selected month. Now I see all the courses for that Place.


Is it possible to do that? I think I will have to work with a global field but do not know where to start ... Attached you'll find what I have.