March 30, 200619 yr Newbies 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.
March 31, 200619 yr 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.
March 31, 200619 yr Author Newbies I think I've got you... anyway you could show me a snippet of code for the Conditional Value List? Thanks!
Create an account or sign in to comment