Dependent Drop-down List

Emanuela Dolce

Hello! Is it possible to create a dependent drop-down list?

I have two text cubes (Contry and City) structured by a dummy entity (a counter) and with data-entry option enabled.

For the first cube the suggested value is the entity country, for the second one the suggested value is the entity city.

If I insert one value in the first cube, is there a way to show as suggested value only the cities related to this country?

Graeme Whorrall

Hi Emanuela,

 

can't see a nice way of reducing down the selection list but you can validate that the city is in the country selected else return an error like "city not in the UK" when they try to save it. (rules would be quite long)

 

Or have it so they select the CITY as an entity which is related to the country and then these can be written to text cubes if necessary. 

 

Regards

 

Graeme