I have a variable called country which is reference to location table, and having a another esn tabl

[Archana23]

I have a variable called country which is reference to location table, and having a another esn table there we have almost 60 countries, we need to show only 60 countries that too we need to refrernce it to location table only.

Please suggest me

[Community Alums]

Hi @Archana23 ,

Your question is not clear, can you elaborate more with some screenshots please .

what is "esn table"?

[Ankur Bawiskar]

@Archana23 

what's the purpose of both the variables?
what's your business requirement here?

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

[Archana23]

Esn table is a custon table(u_esn_codes), having almost 60 countries. The thing is this custom table cannot be used , so we need to show only these 60 countries, in the 2nd screenshot having country variable need to show only 60 countries which are available in the custom table but need to give refrence to cmn_location table.

[Ankur Bawiskar]

@Archana23 

so 2nd variable should show only those ESN codes for the country selected in 1st variable?

if yes then apply advanced ref qualifier as this

Note: Use correct country field here from ESN table and also the variable name

javascript:'u_countryField=' + current.variables.countryVariableName;

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