BradElmore
4 years agoQrew Assistant Captain
Report Link - based on User field - to - List User field
I have a Employees table and a Projects table --
Employee Table
-User Field
Projects Table
-List User field
Example
Employees
-Employee A -- User Field = Bob
-Employee B -- User Field = Tim
Projects Table
-Project A -- in my List User Field I have selected (Bob & Tim)
-Project B -- in my List User Field I have selected (Bob)
I would like to create a Report Link field - within my Employees table -- this Report Link field will be used on the Employee record form to display related Projects.
Currently -- My Report Link field I have created - (based on exact match) -- For Bob --- I only see Project B -- I want to be able to see both Project A and Project B -- If I uncheck the Exact Match -- I do not see any related Projects.
Is it possible to create a Report link field that will show both Project A & B (for Bob) -- or any suggestions --
thank you
------------------------------
Brad Elmore
------------------------------
Employee Table
-User Field
Projects Table
-List User field
Example
Employees
-Employee A -- User Field = Bob
-Employee B -- User Field = Tim
Projects Table
-Project A -- in my List User Field I have selected (Bob & Tim)
-Project B -- in my List User Field I have selected (Bob)
I would like to create a Report Link field - within my Employees table -- this Report Link field will be used on the Employee record form to display related Projects.
Currently -- My Report Link field I have created - (based on exact match) -- For Bob --- I only see Project B -- I want to be able to see both Project A and Project B -- If I uncheck the Exact Match -- I do not see any related Projects.
Is it possible to create a Report link field that will show both Project A & B (for Bob) -- or any suggestions --
thank you
------------------------------
Brad Elmore
------------------------------