Hello All:

I have seen layouts which display different Value Lists for a field
based on the value of another field.

I have been reading the documentation to figure out how to do this but
so far I have not found the gold mine...

Any help to set me in the right direction is appreciated.

Sam

In article <1126723857.663637.242480 (AT) z14g2000cwz (DOT) googlegroups.com>,
"SamMc" <FMP_account (AT) hotmail (DOT) com> wrote:

First, it depends on what version of FileMaker you are using.

In FMP 7 or 8, you have the option of defining a value list to take
values from a field. You specify what table and what field to take the
values from. it seems pretty straightforward to me. If need be, use the
Help file for guidance.

I think you had this ability in FileMaker 6 also, though I am forgetting
the details of FMP 6 as I have gone over entirely to FMP 7. I don't
think this capability exists in FMP 4 or earlier.

Bill

--
For email, remove invalid.

Hello Bill:

What you are describing is not what I meant. Here is an example.

Suppose that I have two fields:

Animal_Type
Animal_Name

Let's say that Animal Type can be:

bird
reptile
mammal

If the user enters 'bird' for the Animal Type, I want the Animal_name
to go to a Value List for birds that would display:
parrot
eagle
gull

If the user enters reptile:
snake
crocodile

etc.

Thanks!

Sam

Sam
I am new to FM8 and am experimenting. The following seems to work. Don't
know if earlier versions of FM had this ability.
Michael Paine

1. Establish a relational link for Animal_type between the Primary and
secondary tables (using File/Define/Database).
2. Create a Value List (File/Define/Value List) from Animal_name field
in the the secondary table BUT ensure you select "Include only related
records starting from" and choose your Primary table (this is part of
the Specify dialog). Call it, say "name_lookup".
3. Add a drop down list to the layout for your primary table and select
the name_lookup value list for "Display values from".


SamMc wrote:

Seems like a good strategy. I will try it and report back.

Thanks!

Seems like a good strategy. I will try it and report back.

Thanks!

I am finding out that the topic "Example of a value list that includes
only related field values" covers what I want.