Contextually assigning value lists - behavior as valuelist - Value Lists

January 6, 201214 yr

I want to contextually assign different value lists to a field.

For example:

if field Select_VL is "VLB"

then field VL displays value list B

Its trivial to display the contents of the selected value list using the function:

ValueListItems ( fileName ; valueList )

For example:

Set Value List Related Example.fp7.zip

However, the field contents do not behave like a value list. It is not possible to select a particular item from the value list, have it auto complete, etc.

For example:

if field Select_VL is "VLB"

then field VL displays: Garlic

Red

Rock Music

But field VL just behaves as an ordinary text field, not as a value list.

I would like the displayed data to behave like a value list, so that it is then possible to select from it and so use relationally.

Is there a way to do this?

Thanks,

-Steve

January 6, 201214 yr

Try it this way, perhaps?

Set Value List Related2.zip

January 7, 201214 yr

Author

Once I fixed the relation (checked "allow creation of related records") your solution worked fine.

Unfortunately, the example I provided was simplified in that the different classes which I need to differentiate between occur in the same record.

Here's a file with a little bit of the actual data I'm dealing with:

Synonomy - Data.fp7.zip

The intent is to allow botanists to choose the synonomy they wish to use (e.g., "USDA_Plants," "Hitchcock," "WaFlora"), select a particular species, and have the other synomyns (other names) for that species displayed. I had originally considered doing something like you suggested, but didn't see how to make it work in this situation.

I just spent a while trying to create a setup with the different classes (e.g., "USDA_Plants," "Hitchcock," "WaFlora") and their values split into separate tables, but wasn't able to solve the problem. Garghghgh!! This seems like there should be a simple elegant uncomplicated solution.