Is there a way to insert a value list field into another field? I'm working on a script that allows a user to choose 1 of 4 groups, the next step would be to choose from a value list based on what group they selected. I've tried the ValueListItems function, but it only returns what's in the list, it won't let me choose one value. Any advice is appreciated.

quote:

---

Originally posted by smoothdra:

Is there a way to insert a value list field into another field? I'm working on a script that allows a user to choose 1 of 4 groups, the next step would be to choose from a value list based on what group they selected. I've tried the ValueListItems function, but it only returns what's in the list, it won't let me choose one value. Any advice is appreciated.

---

This is called a "hierarchical value list". Basically a second value list will have values that depend on what value was selected in the first value list.

Which version of FMP are you using? FMP v5 supports this kind of functionality directly. If using FMP v4 or lower, you kinda need to create the functionality yourself and I would consider that to be a pretty advanced function.

Good news is that there are several good demo files of how to accomplish this. http://www.advisor.com would be a good place to search for them. Anybody suggest some others?

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

I am using FMP 5.0, I am trying to do a self join, and defining a valuelist with the 'use values from field' option. Am I on the right track?

have a lo at http://www.databasepros.com thay have a lot of downloadable examples, a couplke of which are different ways to achieve hierarchical menus. None of them are uncomplicated, if you get my meaning. ;-(