How to make dependent between 3 variables in record producer

[yugesh k]

Hi All,

How to make dependent between 3 variables in record producer?

I have created 3 variable 

1) Country

2) Company

3) sub company

 I select country "IND" it need to show companies under IND & then selected company "A" it need to show sub companies under  A.

Thanks & Regards

[_Gaurav]

Hi @yugesh k 
1. In this case, either you need to create 3 onChange catalog client scripts or make fields read-only and make them editable only when the above fields have value.
2. If all those 3 variables are of reference type then just use the reference qualifier to achieve the functionality.


Please mark this as helpful and accept it as a solution if this resolves your query.

Thanks!

[Sohail Khilji]

Hi @yugesh k ,

You can do this with creating a reference qualifer for company and subcompany field. 

or 

you can create a function in a script include and return the Encoded Query with all filter conditions.

Then just call that function in the Reference Qualifier. Passing the previous field value in qualifier parameters.

I HOPE THIS HELPS...

[yugesh k]

Hi,

All this 3 fields are choice fields.

[_Gaurav]

@yugesh k 
Then you can use the onChange CS and script include to perform