Value List

[FaeryHigh]

Another rookie question.... Is it possible to have selected values in one value list checkbox set automatically select values in another value list checkbox set?

i.e. VT or ME or NH equal North Atlantic

[Ender]

You can define an auto-enter calc in the region field's definition, like:

case(State="VT" or State="ME" or State = "NH"; case(patterncount(Region;"North Atlantic")=0;Region & "¶North Atlantic"; Region);

State="MN" or State="IO" or State = "WI"; case(patterncount(Region;"Midwest")=0;Region & "¶Midwest"; Region);

...

)

Or you could consider a relational setup, where the states are chosen in a portal (a portal of Selected States), and the Region is just an attribute of the State. If you needed a unique list of the Regions, there are a number of ways to pull those out of a related list of records.

Edited June 15, 2007 by Guest
fixed syntax