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

    Value List Based on Multiple Criteria


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

      Fruit Basket


      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.