How to populate a Multirow variable set field based on another field which is on the same MRV set.

[Dush2]

Hello 
I am developing a catalog item that has a Multirow variable set.
I have a scenario where one of the lookup select box field ,defined on Multi row variable set needs to be populated based on another field which is too on the MRV set. (CustomerSysID)

For example , I have a visitor table where an  visitor is linked to a customer.
So my requirement is to display/ filter a set of visitors into a field (Visitors for the Customer) on MRV set for a certain customer of whom the sys_id is captured to a field (CustomerSysID)on the same MRV set. (please check beneath image)

Is there a way I can do it?????

I have tried some ways to introduce a advanced reference qualifier to the field Visitors for the Customers field on the MRV set.

javascript:'u_active=true^customer_name='+current.variables.thn2_dc_access_cust_sysId;

But it does not work.
Because the system does not access the CustomerSysID field in above way, but if I provide the hardcoded literal value (sys_Id of the customer) the expected result comes ( I have done it for testing purposes).

Please share your thoughts with me to accomplish my requirement.
many thanks

[Shruti · Accepted solution]

Hey,

Try to add Variable attributes to the Lookup select box variable

ref_qual_elements = thn2_dc_access_cust_sysId

[Community Alums]

I had a similar need and this worked. Thank you