related value list

[s-A]

Hi, I'm wondering if it could be possible to create a value list in relation with another one.

I mean, for instance, I have my first value list, which is the specie, and I have the second one, that is the breed. If I choose "bovine" in the first one, I would like to have only bovine's breed in the second value list, instead of having ALL of the possible breed of bovine, horse, pig, etc. Is this possible?

[bcooney]

If a Breed can only have one Species assigned to it, then you do not need a condt'l value list. Can't you just select the Breed directly? Each Breed record should have its SpeciesID.

See demo.

However, if you want demos of Condtl Value lists and many other goodies, see comment's blog:

http://fmforums.com/forum/userpage.php?uid/21152/

sA.fp7.zip