>>I've come across a combobox situation that is new to me and I would appreciate a brief tutorial. The function is basically a lookup. My difficulty is that I want to store one field and display another. The situation is this:
>>
>>Maintable1 has an integer field to store employeeID.
>>The combo.controlsource is maintable1.employeeID.
>>The combo is populated from lookuptable.employeename and lookuptable.employeeID.
>>The combo will display the employeename both when it is open and when it is closed.
>>
>>Is this possible?
>
>* combo.init
>
>with this
> .RowSourceType = 3
> .RowSource = "select employeeName,employeeID from lookupTable into cursor crsCombo"
> .ColumnCount = 2
> .ColumnWidths = "100,0"
> .BoundColumn = 2
> .ControlSOurce = "myTable.myField"
>endwith
>
>Querying what's selected:
>luSelectedID = crsCombo.employeeID
>
>Cetin
Thanks guys. You were both helpful.