Forum Discussion

Qrew Captain

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

reports and charts

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 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
Qrew Captain
5 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
  Qrew Elite
  5 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
    Qrew Captain
    5 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
    ------------------------------