AnsweredAssumed Answered

Value List Based on Multiple Criteria

Question asked by director@charlesmoore.org on Dec 11, 2016
Latest reply on Dec 12, 2016 by philmodjunk

Can anyone help me with this general problem?  Say I have these tables:

Fruit Basket

Fruit

Fruit Color

Fruit Type

 

The tables are related to each other in the obvious fashion.

 

When users are filling their Fruit Basket, is it possible to set up a Conditional Value List based on BOTH choices of Fruit Color AND Fruit Type (2 separate fields from two separate tables) so that the Value List created for Fruit automatically limits itself?

 

Feel free to fiddle with attached sample.

 

THANKS!

Attachments

Outcomes