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:

*-- Stock Column
Grid.grcStock.ControlSource = "Stock.Description"
Grid.grcStock.Bound = .F.

*-- Stock Column.Stock Combo
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.