Thanks Barbara, but I've already tried that. The problem is that the textbox insists on showing the underlying data and displays the foreign key instead of the text...

>Interesting challenge!
>
>I'd put both a textbox and a combo in the grid column. When the cursor goes to the column, populate your combo correctly. This could be either on-the-fly or using a pre-set series of cursors or arrays depending on whether there are many choices or only a few. When you exit the column, return the current control to the textbox. Of course you'll need code in the combo to store the value to the correct field, etc.
>
>HTH
>Barbara
>
>
>>Just stumbled over a new challenge:
>>The request is for different Combo contents in one column in a grid, depending on value in another column.
>>
>>Simplified example, first column is flag for Combo type/content, second for foreign key from Combo:
>>
>>Row 1: 1, 0 -> Here I want a combo with Orange and Lemon
>>Row 2: 2, 0 -> Here I want a combo with Apple and Pear
>>
>>I do, of course, want the text of the selected item to remain when the user moves to another row...
>>
>>I've fooled around a bit with this, and the only way I've found so far is by using a dummy character column to keep the display value. Obviously I'd like to avoid this...
>>
>>Any ideas how to accomplish this?
>>
>>TIA,
>>Arne