Conditional Value List Questions

[kfok]

I have set up a conditional value list for the attached file. There are three fields, Country, State and City. When users select a value in Country, the available values in State will show up, and when users select a value in State, the available values in City will show up. This works for countries containing values for all three fields. But problems exist for countries with no value for State. For example, when users select France in Country, no value shows up in State and in City as well. But I want cities of France to show up in City.

Is there a way to do that? Thanks in advance for any input.

test.zip

[Kent Searight]

Do the same thing you did for Canada, which has provinces, as does France and Germany. I'm not sure how the UK is divided but I think it's counties.

Something that might be kinda cool would be to make the field title change according to the country selected, in other words if someone chooses Canada, then the field title changes from state to province.

[kfok]

Does anyone know how to do the conditional value list as I posted? Thanks in advance.

[-Queue-]

See my response on ISO FileMaker.