>*** It's possible in a Combobox, when the list open, have something like this:
>(This is from same Table but diferent Fields)
> SALES IN NEW YORK
> Jhon
> Smith
> Mc Claud
> SALES IN TEXAS
> Mc Gree
> Mendez
>
> or with two columns:
>
> SALES IN NEW YORK
> Jhon
> Smith
> Mc Claud
> SALES IN TEXAS
> Mc Gree
> Mendez
It's up to you to collect any kind of data into cursor and use it as Combo.Rowsource, e.g.
CREATE CURSOR curCombo (descript C(10)
select table1
scan
do case
case field1=1
insert into tmp values(table1.field2)
case field1=2
insert into tmp values(table1.field5)
...
endcase
endscan
Thisform.Combo1.rowsource="curCombo"
Edward Pikman
Independent Consultant