6 Replies Latest reply on Dec 12, 2016 9:05 AM by philmodjunk

    Value List Based on Multiple Criteria

    director@charlesmoore.org

      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!