Filtered Value List

[blissland]

I think the answer to this is likely simple. In the real world I'm taking soil samples and counting the numbers of individuals of species in each sample. In FMP 9 I've got Samples, Sample-Species, and Species tables. On a Samples table layout I have a Sample-Species table portal on it in which for each record I have a dropdown menu for Genus and a dropdown menu for Species. When I select the Genus, I want the Species list to be filtered by Genus. Genus and Species are two fields in the same Species table.

I've tried a variety of relationship graph arrangements but I can't seem to do this simple logical thing. Thanks for your help.

[Phillip Holmes]

Hello,

Have you carry out a search in the forumn looking for "Filtered Value List". There are many posts about this subject maybe the solution is listed in one of the replies.

Regards

Phillip

[comment]

I believe searching for +conditional +value +list would be more productive. Anyway, this is quite simple: in addition to your basic setup of

Samples -< SampleSpecies >- Species

define a relationship between SampleSpecies and another occurrence of Species as:

SampleSpecies::Genus = Species 2::Genus

and tell your value list to use values from the field Species 2::Species, showing only related values starting from SampleSpecies.

---

Note that "Sample-Species" is NOT a valid table name.

[blissland]

got it. thanks!