Table/Query or Value List field lookup whose content depend on another field's content. How-to?
Posted on 2016-11-23
I'm trying to design an Access table in which a field named "Choice" would present, in datasheet view, a dropdown list whose possible values would depend on another field named "Category".
For example, say a record would have " Category='Color' ", then field "Choice" might present a dropdown list with 3 possible choices : "Red", "Green", and "Yellow". However, if it would be " Category='Fruit' " the dropdown list would show 2 possible choices : "Apple" and "Orange".
In other words, the value of the "Category" field would determine the available options in the "Choice" dropdown.
How can I do that?