Is it possible to set up a series of related parameters.
for example
if i pick the UK from a parameter asking me what Country i then want a parameter to ask me what City (and only display the Cities relevant to the UK)
In the database there is a link between the country and the cities that belong to it.
The only solution i can think of is if i make a formula field which concatenates the two fields together and then do the parameter based on this field.
is there another way ?
cheers
for example
if i pick the UK from a parameter asking me what Country i then want a parameter to ask me what City (and only display the Cities relevant to the UK)
In the database there is a link between the country and the cities that belong to it.
The only solution i can think of is if i make a formula field which concatenates the two fields together and then do the parameter based on this field.
is there another way ?
cheers