Hi Jayesh,
Establish the relationship between the Detail table used in grid with the Stock table.
Here is an example which shows the necessary settings required:
Grid.grcStock.ControlSource = "Stock.Description"
Grid.grcStock.Bound = .F.
Grid.grcStock.cboStock.ControlSource = "DetailTable.cStockid"
Grid.grcStock.cboStock.BoundColumn = 2
Grid.grcStock.cboStock.RowSourceType = 6
Grid.grcStock.cboStock.RowSource = "Stock.Description,cid"
Moreover, you might also have a look at the TasTrade example which comes with VFP. It uses the same concept.
>I am having a combo in a grid which displays the stock table field say name but actually stores stockcode in the table.What control source am i supposed to mention in the column's control source and what in the combo's control source? what the bound property of the table should be set to ? and should there be a relation between the stock and the child table?
>
>Regds.
>Jay.