>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.
Edward Pikman
Independent Consultant