6 different value lists in one field

[lesterd]

I want to create a calc or script that lets me put a number in one field and a corresponding value list of 3 or 4 choices shows up in a second field.

For example: I have a field called grade. If grade 1 is picked than the values B5,B6, and B7 come up in a field "Room #" when clicked (drop box). When someone picks or find "Grade 2" then a new value list of B2, B3, B4, and B8 would come up as a choice in "Room#". I have 6 grades and 6 different value list.

Thank You

Lesterd

[email protected]

[cjaeger]

You will have to set up a relation to a file "valuelists" on grade.

the valuelist field will have 2 fields, grade & room#:

grade room#

1

[danjacoby]

This is one instance where I actually recommend using repeating fields.

In the "ValueLists" file, each grade would be a different record, while the Room field can be a repeating field.

[Todd Dignan]

Attached is an example of a calculation valuelist and a ValueList based on a Relationship. Enjoy.