How to show only values in reference field which are in the list field?

[SKy Nachiket]

Hi Everyone,

So I have a requirement where I am working on a form and it has two fields : Project Manager(reference field : User) and Additional Project Manager(List field-referenced to User) where additional project manager can be assigned.

So now let's say there are four members added in the Additional Project Manager field and saved it, now when I click on the lookup icon of the Project Manager field, only those users should be visible which are selected in the Additional Project Manager Field.

Please help if anyone has a solution.

[Ankur Bawiskar]

Hi,

in Primary project manager make the Reference qualifier as advanced

javascript:'sys_idIN' + current.project_manager_field;

Regards
Ankur

[SKy Nachiket]

Hi all, thank you for your support I got my solution Thank you so much @Sai Kumar  @Ankur Bawiskar .