Hey, I have 2 tables
Table A - Manager
Table B - Emp, Manager
I have made Manager (field in Table B) as a lookup column referring to Manager (field in Table A). I want to filter the lookup picklist for each cell so as to exclude the Emp name in that row.
As per the above example, for first Emp “AB”, There should be only 2 options showing as “CD” and “EF” instead of 3. I have been trying to use the filters but have no success as of now. Can anyone please help?