Discussions

Expand all | Collapse all

Filtering over a Many to Many relationship

  • 1.  Filtering over a Many to Many relationship

    Bronze
    Contributor
    Posted 05-14-2018 14:42
    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


  • 2.  RE: Filtering over a Many to Many relationship

    Bronze
    Contributor
    Posted 05-15-2018 14:23
    Update: I realized that a multi-select text field instead of a category table worked way better and did everything I wanted it to.