Filtering over a Many to Many relationship

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
I have set up a basic many to many relation ship between two tables, Features, and categories. Since each feature can have many categories and each category can have many features, I have set up a join table in between them, "Assigned Categories". 

However, my users typically interact with the app through the "Features" table, not the "Assigned Categories" table. Is there a way allow users to filter my "Features" table by category, without having to go into the join table?

Thanks
Photo of Alex Gale

Alex Gale

  • 1,124 Points 1k badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Alex Gale

Alex Gale

  • 1,124 Points 1k badge 2x thumb
Update: I realized that a multi-select text field instead of a category table worked way better and did everything I wanted it to.