>Jason,
>The way I do it is to have two controls in the column: a textbox bound to the Worker Name as well as the combo box. When the column is active, set the CurrentControl property of the column to the combo. When the column is inactive, set CurrentControl to the textbox.
>
Why not use a combobox with multiple columns; make the WorkerName the first column, and a later column that is not displayed as the BoundColumn?
>HTH
>Barbara
>
>>I am having trouble with a grid. I have three tables :
>>Table 1: Ticket table
>> TicketID
>> Ticket info, etc.
>>
>>Table 2: Ticket workers (can have many workers associated with 1 ticket)
>> TicketID
>> WorkerID
>>
>>Table 3: Workter table
>> WorkerID
>> Worker Name
>> Worker info, etc.
>>
>>On the ticket entry form I have a grid with the worker information in it. The grid is setup to display/store the WorkerIDs in table 2, it uses a combo box in a single column. The combo box works fine, but the grid shows the WorkerID when not in focus. What is the property that I need to change to display the name from the combo box instead of the WorkerID?
>>
>>Thanks in advance for any help.
>>Jason Lund