Dynamic Value Lists

[KarenH]

I need a plug-in that allows you to see a different value list for a field depending on what value is entered into aanother field. This is for a subcategory field and I want a different list depending on what main category is selected.

[LiveOak]

If you are using FM 5, you don't need a plug-in to do this. You can do this by creating a file for your value lists. Say the field in your original file that needs a selective list is the field "Name". Create a new file has the fields:

Group (text)

Name (text)

In your original file, create a global text field "gGroupSelect" and create a relationship with "gGroupSelect" related to "Group" in the new file. Give gGroupSelect in your original file an ordinary value list (animal, vegetable, mineral). Now create a new value list choosing values from a field, select your new file, the field "Name" and "only related values". Assign this value list to the "Name" field. (and don't forget to fill out the groups and names in the new file!)

Now when you select a Group (animal), the value list shown for the "Name" field with change based upon the group selected (horse, cat, dolphin).

-bd