Hi!

1. Combobox's list should have description as the first column.
2. Use sparse property of grid to show combobox in all rows.

If you dont want to show combobox in all rows, you can use a container as a cell and show different


>I want to put a combo box (list box mode) in one column of a grid. The control source for the column is a numeric foreign key to a related lookup table. I can populate the list in the combo box with the primary key and description from the lookup table. I can also hide the primary key column in the combo box so the user only sees the description column. I even have it working so that when the user selects a description the corresponding primary key number is transferred to the control source (the foreign key).
>
>What I can't figure out how to do is to display the description in the grid column once the selection has been made. All that I am able to display is the value of the control source which is the numeric foreign key. I am able to do this all day long using a combo box by itself on a form, but can't figure out how to make it do it with a combo box on a grid.