Formula to filter one to many relationships



I have a student / courses many to many relationship. I’d like to have a column in the Students table with only the current year’s course. Is there a way to to this using a formula? It guess it would have to filter according to the year column of the Courses table. If courses.year = 17 () Is this in any way possible?


I think you need an extra table to handle that Many-to-many relation. I leave a help article: