3-Tiered Popup Structure

[lakapper]

I'm not sure if this is considered a conditional value list or not, but I need to develop a cascading popup structure that goes from Countries to First Level Administrative districts (states/provinces/etc.) to Cities.

Any suggestions with supporting examples (if possible) would be great.

[mr_vodka]

See this thread.

Basic Conditional Value List

[lakapper]

I found this thread, but it is only a two level structure. It seems like there might be a bit more complexity in adding the next tier. Is that an accurate statement? Thanks for the reply btw.

[Genx]

Hi lakapper.

The third is not really any more difficult than the second. Simply relate the third to whatever the unique identifier for the second value in your first table is..

Actually that probably doesn't make any sense to you. Can you post an example of your scenario (there are a few different ways to implement this based on the way you are actually sourcing your data). E.g. Do you have a table for each of Countries, States, Provinces etc. or have you just dumped everything into one table? Are you using Id's or text?

[lakapper]

I'm using text and I sorta figured out what you meant. The only problem I still notice is that if you modify a tier after the initial entry...how hard is it to modify the structure so that if you change a country then all the other values reset to null...is that just a script?

[Genx]

Take a look at http://fmforums.com/forum/showtopic.php?tid/187106/post/252009/hl/clear/fromsearch/1/#252009 and then the follow on link from Comment in that topic if required.

[lakapper]

Thanks GenX I really appreciate your help. That worked beautifully. I was a little worried about it working over multiple popups, but because one gets modified. It works very nicely. ******* sure I would never have come up with that script in a million years lol. Thanks again.