>I can't believe I'm having a problem with this...........
>
>I have a ReasonCode table
>idReason Int
>cReason C(20)
>cExplanation C(200)
>
>I have a grid whose RecordSource("crsGrid") contains an idReason field.
>
>I need a drop-down combobox which shows cReason value as both the displayvalue and the drop-down list, but puts the proper idReason into crsGrid.
>
>What are the proper properties to set on the combo-box
>
>TIA.............Rich
ColumnCount = 2
RowSourceType = 6
RowSource = "ReasonCode.cReason, idReason"
BoudCoulmn = 2
BoundTo = .t.
Value = 0
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.