Hi, My name is steve and I am trying to use value lists from a field. That much i can do. But what I would really like to do is to have one field as a value list and on the basis of that choice be able to get the next field to reduce its options. I have a feeling it is to do with value lists based on a second field and setting up a relationship. I have to admit to fumbling around in the dark.

It is called Conditional Value List, or Dynamic Value List.

Do a search of the Forum For [color:blue]+Conditional +Value +List and you should find a lot of post about how to do this.

There a few sample files here, and at some of the sponsors sites such as DatabasePros.com (see the link above the Large FMForum Title).

HTH

Lee

thanks - i will follow your instructions.

This may help...

http://www.filemakermagazine.com/videos/hierarchical-value-lists-dependent-value-lists.html