this example has been used before so i will use it too but change it a
bit:

I want to make the value list used in one field to be dependent on the
value of other fields in the record.

For example, the following record is stored in a different file:

Country = "United States"
State/Province value list = "Alabama, Arkansas, etc" and
Value List 2 = "red, white, blue, etc " and
Value List 3 = "Dodge, Oldsmobile, Ford, etc" and

now if some one selects United States as the country in a different
file than the one above, then i would like ONE menu/list to show up
with all the values from the three lists.

so I the menu would appear as: "Alabama, Arkansas, ..., red, blue,
white, ..., Dodge, Oldsmobile, Ford, ...etc"

is it possible?

TIA