User filter-User Mapping
I have been stuck on this particular issue for sometime now, wanted to check if someone here could help me out:-
I wanted to filter list items of List A for the end user based on a non system users list subset.
I have a module 1 dimensioned with list A, one of the line items in that are list formatted to a non native users list subset (Approver). So basically every list item of list A will have its own user selected from the non native users list subset, Approver.
I have module 2 also dimensioned by list A, wherein in the dashboard I want to ONLY show the current user those listitems based on the 'Approver' line item in module 1.
Example, If List A has list items like Apples, Oranges and Banana. And if XYZ has been selected as approver for Apples and Banana in Module 1.
When XYZ logs on to module 2, XYZ should only see Apples and Banana. The user allotted with Oranges should not see Apples and Bananas.
How can i create a filter wherein the current user using the dashboard is checked with the Approver line item. It would be really helpful if someone can help me figure this, thanks!