I have a grid and one of its columns have a combo to select one article.

To chose the value i did an SQL search whith this code
Select article,idarticle from aticles order by idarticle into cursor Carticle. And then i add idarticle to other table.


Every thing works fine at that point but i want to view the name of the article instead of the id on the combo.

My control source is idarticle in the combo

TIA
-eduardo