Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox with ROWS from different Fields.. Its Possible?
Message
From
30/04/1998 16:28:13
 
 
To
30/04/1998 16:15:19
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00096112
Message ID:
00096117
Views:
16
>*** 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
Previous
Reply
Map
View

Click here to load this message in the networking platform