Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Cannot Dynamic Filter in Many to Many Relationship

I am creating a table for all of my Company Procedures so that we can work on documenting them for new and existing employees.  As this list can get a bit long I want to be able to associate a Departm...
Many-to-Many
Relationships
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Your design is correct. Check if the department field on your join table is set to searchable.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago
The way I am carrying over the names is a summary combined text field.  Since it is one to many.  Am I not exposing the right field somewhere?

This is a screenshot of the relationship of the join table:

This is a screenshot of the field connections between the join table and the parent table procedures.  


------------------------------
Ivan Weiss
------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    Ivan,

    The Department Name will be in the other relationship of the Join Table.   Procedure Title passes to the Join from the one in your screen shot.


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      Happy New Year everyone.  This is the other side of the relationship screenshots.  I guess what I am not fully understanding is how I get the data from reports to procedures.  I have built the report on the procedures table.  So I am not sure how to get through the many to many relationship to the other side.

      Or did I do that wrong and should the report be built on the join table?  Maybe that is the entire issue?


      And the settings on the department name field


      ------------------------------
      Ivan Weiss
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        Re:

        Or did I do that wrong and should the report be built on the join table?  Maybe that is the entire issue?

        Exactly. The join table us a child of both tables, so you lookup any fields you need from both Parents down to the join table.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------