Help

Re: Formula to filter one to many relationships

Solved
Jump to Solution
477 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark_Dixon
6 - Interface Innovator
6 - Interface Innovator

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?

1 Solution

Accepted Solutions
Elias_Gomez_Sai
13 - Mars
13 - Mars

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

See Solution in Thread

1 Reply 1
Elias_Gomez_Sai
13 - Mars
13 - Mars

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