Predefined Value list as result of case function

[AirCraft]

Ok, here's the scoop:

I'm trying to create a dynamic portion to my DB for what will eventually be implemented on the web. Basically I will have a series of drop-down menus where the value list of the second drop down menu is contingent on what is selected in the first value. So I imagine I will use the Case function...

Case(Short_ID="JAZZ"; result is Jazz subcategories appearing in the Subcategory Drop-down list; Short_ID="BLUS"; result is blues subcategories appearing in the same Subcategory Drop-down list... and so on. Does this make sense? is it even possible? Thanks for your help, this exceeds my filemaker knowledge.

[Kent Searight]

Calculation's the wrong approach. You'll need to set up a relationship using "Short_ID" as your key to create a conditional value list.

But there's a catch to your specific requirement ...

Conditional value lists are created by committing the record on IWP. Simply tabbing-out-of/exiting a field won't refresh them on IWP as it does in FileMaker client. This means you'll probably want a script to run after a user selects the first value.

[AirCraft]

I think I've got you... anyway you could show me a snippet of code for the Conditional Value List?

Thanks!

[Kent Searight]

Try this...

ConditionalValues.zip