I have a data island with 2 fields : Category; Option
[Option] is displayed to the end user in a listbox.
Depending on other general selections, I want to limit the [Option]s displayed.
So I have a trigger that filters [Category] when required.
So let's say [Category] = 'Apple'
The trigger filters the list, and it shows :
> Available (White) items : 'Red'; 'Green'; 'Pink'
> Unavailable (Grey) : 'Blue'; 'Black'; 'White'
That all works well, but ....
If a user now selects [Option] 'Red' ; then ALL other options become grey.
There is no longer a distinction between those that are
- available for [Category] Apple, but not selected
and
- those that are NOT available for Apple at all.
Is there a solution for this ?
Ideally I'd like to display ONLY the options available after filtering [Category]
and of the remaning; behave like a normal list.
