Skip to main content
Solved

Formula to filter one to many relationships

  • September 7, 2017
  • 1 reply
  • 28 views

Forum|alt.badge.img+6

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?

Best answer by Elias_Gomez_Sai

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-relationships

1 reply

Forum|alt.badge.img+17

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-relationships