Steve --- Check your BoundTo column setting.
>
>I have parent-child relationship and the grid is the child. I one of the column in the grid is a combo box. This grid itself is using a separate table and the combo box is using a field from a different table, but everytime I select different value from the combo box. The value from the table won't change to the value that I selected from the combo box and the record keep on pointing to the first one on the table. Does everyone knows why? This is what I have in the grid and combo box.
>
>grid1 > ChildOrder = prod_code
> LinkMaster = Products
> RecordSource = Suites
> RecordSourceType = 1 - Alias
> RelationalExpr = prod_code
>
>grcProduct > Bound = .F.
> ControlSource = Suites.code
>
>grcProduct.cboProdCode > BoundTo = .F.
> ControlSource = Suites.code
> RowSource = Products.prod_code
> RowSourceType = 6 - Field
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05