1 of 1 people found this helpful
When you use the value in one field to control what values appear in a value list set up on another field, this is called a "conditional value list".
This free download file demonstrates 10 different methods that can be used to create conditional value lists:
There are several hierarchical conditional value list examples. Which are you trying to replicate? What you described in your original post was not a hierarchical conditional value list but something that can be accomplished with a basic conditional value list. I'd see if you can get a basic conditional value list working before attempting on of the more ambitious hierarchical conditional value lists.
I took a quick look at your file and it has a number of problems.
a) I don't see any field set up with a value list format such as a pop up menu, drop down list, or other such option
b) One layout is not based on any table occurrence at all. Nothing is selected in Layout Setup|Show records from
c) none of the value lists are correctly set up with the "Include only related values" option as is required to set them up as conditional value lists.
I managed to get the 1st and second field (Area and Goal) in conditional validation but not the 3rd (Objectives).
May someone point to what I'm missing. I am displaying my form, relationship and VALUES table.
I'm taking a break from DevCon to make the one post per day that is all one can post from an iOS device.
A "use values from field" value list can only list values from two fields. But by selecting a value from a list, you can use a relationship based on that field's value to access any additional data from that related record.
Thank you PhilModJunk. I'll try to make to the next DeCon. Save trip!