Choose a value list based on a(nother) field?

[Barker]

Is there any creative way to have FM pull up a particular value list (i.e., "Type List For Class ______") based on the value of another field (i.e., "Class")? I don't want to involve button-driven-scripts or to require users to manually change layouts.

BACKGROUND:

I have a database where I have a field that is filled with a number of "Classes", and a number of "Types" -- the types basically being sub-categories of each Class.

Type and Class are seperate fields.

There are so many types that allowing users to choose from a value list of all the types entered thus far is becoming extremely cumbersome!

So what I want is to only show value list based on the class, so there would be numerous value lists for types.

I know I can do this by creating numerous seperate "type" fields, and having a seperate value list for each, but this raises a number of problems -- e.g. you can't search from the entirity of types (i.e., all various class/type combos combined) without creating a unique field (and corresponding layout components) that would be used solely for searching. Likewise, you'd need unique layouts (or layout components) for creating each various class of a new record (so as to access the various value lists). This creates a lot of extra steps for users, and makes use of Ctrl+N and Ctrl+F problematic (user would need to be in the correct layout to utilize them).

So yes: Is there any creative way to have FM pull up a particular value list (i.e., "Type List For Class ______") based on the value of another field (i.e., "Class")?

[sbg2]

I have previously posted a method I think may work for you,

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=155114&an=0&page=0#155114

Have a look and see if that helps.

[solarpunk]

sbg2,

do you have a way to do the samething with FM 6.0 i am trying to do something like this with DB i am working on. Basically what i want to set up if a user choose Austin from a drop down menu list. i want a second drop dow menu list to show all The programs that correspond to that city.

thanks