I would like to have a single field be able to display several different value lists based on context from another field without doing it relationally or changing layouts.

Example:

There are 2 fields.

field#1 can have a value of a, b, or c.

field #2 will then have a particular value list based on the value in field#1. In this example, there would be 3 different value lists, each corresponding to a, b, or c.

Using a script, I can change the values displayed in field#2:

If [table; field#1="a"]

Insert Calculated Result [table:field#2; ValueListItems [file; "ValueListName a"]

Set Field gives the same result as Insert Calaculated Result.

Unfortunately, while this places the data from the desired value list into field#2, the field does not behave as a value list; the values are not selectible.

Is there any way to do this other than, for example, having 3 different fields, each with a value list, that display based on a relationship with field#1, or changing layouts with each layout having 1 of the 3 different fields?

Hi

I think that there is no other way without a relationship.

BTW: It's so simple to make that relationship ; why don't you want it ?

A desire for elegance and simplicity, but I guess its not possible. Thanks for the confirmatiom that its not posible; that's what I thought.

-Steve