>Hi,
>I have a combo box for selection of the CLIENT table, I want to display the CLIENT_NAME from the combox,
>but the BoundColumn is CLIENT_CODE.
>
>BoundColumn is 2
>BoundTo is .T.
>ControlSource is CLIENT.CLIENT_CODE
>FirstElement is 2
>RowSource is SELECT CLIENT_NAME, CLIENT_CODE from CLIENT in to CURSOR cboClient
>RowSourceType is 3-SQL Statement
>ColumnCount is 2
>
>But it still not display the CLIENT_NAME, display the CLIENT_CODE only.
>
>Please advise.
You need to put Client_Name as a first column. - See how I changed setup of your combo inline.
Alternatively, you can adjust ColumnWidths and set it to 0, 200, for example.
If it's not broken, fix it until it is.
My Blog