>>>I have a grid with a combo box in one of the columns. The combo box when dropped down displays a list of names. After a name is selected, I want the social security number assigned to the name to be returned to the buffered table, but I want the name to always be displayed in the box. The only way I know of to do this is with the bound column property. The only problem with this is that when the combo box does not have the focus the social security number is displayed. Is this something that can't be done, or am I overlooking something obvious? Thanks in advance for any help.
>>>
>>>Andy Ahrndt
>>>aahrndt@mindspring.com
>>
>>Multicolumn combo always displays the first column value, i.e. if you want to display name then make it first column in Rowsource:
>>Combo.Rowsourcetype=6 (fields)
>>Combo.Rowsource="People.Name,SSN"
>>Combo.Boundcolumn=2
>>Another simplified way is to unbind the combo (column) and use one-column rowsource with replace code in Combo.Interactivechange event.
>
>This displays the name when the control has the focus. When the control loses focus the ssn is displayed. I need the name to be displayed when the control has lost focus. Thanks for your quick response.
>
>Andy Ahrndt
>aahrndt@mindspring.com
Column.Sparse=.f.
Combo.Style=2
BTW, thera are two more points:
1. I understand your initial posting.
2. The code I posted was tested (not one time even:).
Edward Pikman
Independent Consultant