Jump to content

Predefined Value list as result of case function


AirCraft
 Share

This topic is 5725 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • 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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5725 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.