How to display multiple columns of the SQL-SELECT cursor in a combobox object in Visual FoxPro

MORE INFORMATION

For a DropDown ComboBox to display an initial value and multiple columns from a cursor created by an SELECT-SQL statement, Microsoft recommends that you use the following property values and methods:

Example ComboBox Properties:

   BoundColumn   = 1
   ColumnCount   = 3
   ColumnWidths  = 0,100,100
   RowSource     = SELECT city+' '+region as MyField,city,region ;
                   FROM Customer ;
                   where !empty(region) ;
                   into cursor MyCursor

   RowSourceType = 3
				

Example: ComboBox GotFocus event

   This.Value = MyCursor.MyField