Formula to filter one to many relationships

[Mark_Dixon]

Hi

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?

[Elias_Gomez_Sai · Accepted solution]

I think you need an extra table to handle that Many-to-many relation. I leave a help article: https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relation...