Can anyone help me with this general problem? Say I have these tables:
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.