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.
From the layout of "Places" based on the table "Places" I create classes (that have a course and a month).
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.
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.