Filtering in ComboBox

Hi Xcelcius gurus!!

I have a small scenario where I need some help.I have the following data in a table.

Codeline System

700 Q99

700 QFT

701 Y1Q

701 QRF

730 Q93

For this I have two combos,Combo1 and Combo2.

In Combo1, I need filtered values from Codeline and in Combo2, I need the corresponding Systems(based on selections of Combo1). Till here, I have suceeded. Now, in Combo1, I need another entry to be appended called "All". On selecting 'All', Combo2 should load all the entries of the column 'System'.

I do not wish to add the ALL in Column and other entries in System

How do we do this?

Edited by: Shashidhar N Garimella on Aug 20, 2010 6:46 AM