Hi David,
I use a combo all the time for look ups where I display the description, but use the id column as in the code below.
I have saved one as a class to show you the settings.
* inv_combobox is just a first sub class from combo
DEFINE CLASS test2 AS inv_combobox
Comment = ""
BoundColumn = 2
ColumnCount = 2
ColumnWidths = "200,65"
RowSourceType = 6
RowSource = "inv_location.location,inv_location.location_id"
ControlSource = "inv_transact.from"
FirstElement = 1
Height = 24
Left = 67
NumberOfElements = 0
TabIndex = 10
Top = 133
Width = 100
Name = "cboFrom"

ENDDEFINE
HTH

>I've had no trouble with single column Combo boxes, but now I am trying to create a Dropdown Combo with two columns. The Rowsource is a SQL Select statement into a Cursor. I want the first two columns to display in the list and both be visible after selection.
>
>When the Combobox initialises, it is blank.
>When the list drops down, both columns are showing fine.
>On selection, only the first column shows in the display. If I can't display both columns, I need the second to display, not the first.
>
>How do I get both columns to be visible when the Combobox is first displayed and also after selection?
>
>I've tried lots of permutations - and searched the help. There must be something simple I'm missing. Can anyone help.
>
>I'm using VFP5a
>
>David O'Brien