I'd point to grocery.fruit_id.

>Hi Mike,
>
>Yes, my cbmo_fruit is displaying the right data. In my grid column, do I use the controlsource to point to fruit.fruit_desc? Right now, I have the column pointing to grocery.fruit_id instead.
>
>Thanks
>
>
>>When you place your cursor in the field, does it show the correct fruit? If >so, I believe you have the combo's right, but you need to change the Sparse >setting of the column containing the combo.
>
>>HTH
>
>>Hi All,
>>
>>I have a form which contains a grid and some combo box fields. I populate the two columns combo box in the init() of the form like the following...
>>
>>select fruit
>>for i = 1 to reccount()
>>With this.cmbo_fruit
>>.addlistitem(fruit_name,i,1)
>>.addlistitem(alltrim(str(fruit_id)),i,2)
>>endwith
>>endfor
>>
>>I stored the fruit_id into the table where I am currently using as the recordsource in the grid. Instead of displaying the name of the fruit like apple, lemon, etc..., I ended up displaying the fruit_id in the grid. The column's controlsource is assign to fruit_id. How can I fix this problem? TIA