>>I'm attempted to display two fields of a table with codes and descriptions to a cbo but i only want to save the code with the record in the main table. I've tried to use columns, but can't figure them out, especially not how to add info to the second column.
>>Ideas are appreciated.
>>
>>Thanks..
>>
>>Jason Nance
>
>Jason, set your Combo.RowSourceType to 6-Fields
>Combo.RowSource = "myCodeSourceTable.description,code"
>Combo.ControlSource = mainTable.code"
>Combo.BoundColumn = 2
>
>Note, that in Combo.Rowsource you have to specify alias only for the first field.
>
>Nick
P.S.
Set the Combo.ColumnCount = 2
and if you don't want to show column with the code in combo
set Combo.ColumnWidth = 200,0 (real ColumnWidth depends on your description length)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison