Filter a table report based on value in another table
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.
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.
