>Dear All,
>
>I used to use a combobox to filter the data to be displayed...like so
>

>.combobox1.rowsource = "select group_name from tableA into cursor tmp_group"
>

>
>However, the user cannot select all groups... my plan is to add a select item into combobox e.g. "Show all groups"... is it possible?

lcShowAll = PADR("Show all groups", LEN(tableA.group_name))
TEXT TO .combobox1.rowsource NOSHOW PRETEXT 15 TEXTMERGE
     select group_name
            from tableA
     UNION
     SELECT  '<<lcShowAll>>' AS group_name
            from tableA
     into cursor tmp_group"
ENDTEXT

or:

.combobox1.rowsource = "select group_name from tableA into cursor tmp_group READWRITE"
.combobox1.requery()
INSERT INTO tmp_group VALUES([Show all groups])