ListBox filtering

[simonb2013]

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.

[Anil_Babu_Samineni]

I read and i may help you regarding this if i understand currently. Can you try this for your list box. I am sorry, If i miss understand your isue

Aggr(FieldName, FieldName)

[avinashelite]

how is your data association ? and how your setting the triggers ?

I think your Category; Option are in same inline table and hence only associated values are showing ...

share the sample app will help you out