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

[yugesh k]

Hi Gaurav,

Making dependent through script is like hardcoded, I'm looking for some other way achieve.

Thanks for your response.

[_Gaurav]

@yugesh k 
I don't think so there could be another way unless you have a separate table created for the same.
I hope the other folks can help you with this.

[Sohail Khilji]

you dont need to hardcode , you can create a sys_propery with json object which returns the encoded query.

{

box1 : 'encoded query1',

box2 : 'encoded query2',

box3 : 'encoded query3'

}