Filter a table report based on value in another table

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I've got 2 tables, Projects and Resources.  

In my projects table I have many fields, of which one is called Segment, which is supposed to identify a market segment with which the project belongs to.

In my resources table, I list users and the Segments for which they are responsible.

What I'm trying to accomplish is creating a report of Projects where the Current User can only see the projects to which Segment they are assigned in the Resources table.

I've tried relating the tables both directions but can't seem to get the filter to show any records, let alone the right ones.

I'm trying to avoid setting up multiple roles.
Photo of Bret Berta

Bret Berta

  • 110 Points 100 badge 2x thumb
  • Frustrated

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Can you explain this a bit more

In my resources table, I list users and the Segments for which they are responsible.  What does a single resource assignment look like in terms of the Assignment to a Segment.  Is the Resource assignment to just 1 Segment or multiple segments on that record.
Photo of Bret Berta

Bret Berta

  • 110 Points 100 badge 2x thumb
A resource is assigned to a single Segment.  In my Segments table there is literally only 2 fields, User and Segment.
Photo of Bret Berta

Bret Berta

  • 110 Points 100 badge 2x thumb
Please disregard, I figured out I had to change the key in my Resources table to the User and link via the Current User and it worked.  Thanks.