Populate users based on other field value

[may13]

Hello team I need help with the requirements below

In a record producer, I have created two variables:

Requested By (which refers to the User table) and

Employee ID (which also refers to the User table).

In the Employee ID field, I want to display only those employees whose company matches the company of the Requested By user.

For example, if I select user ABC in the Requested By field, and that user’s company is "Samsung", then in the Employee ID field should only display users whose company is "Samsung".

[Shashank_Jain]

@may13 ,

To achieve this functionality, you can use advanced reference qualifier on employee id variable - 

Refer the below screenshot :

Hope it helps!

[Ankur Bawiskar]

@may13 

Solution is already shared by @Sandeep Rajput .

Please check that and share the feedback.

If my response helped please mark it correct and close the thread so that it benefits future readers.