>I have a form with two grids, grid1- parent employee file,
>grid2- child activity file.
>
>I have a textbox to hold the sum of activity.hours, but it seems to just display the final record value, not the sum. Here's the code I have in RowChange of Grid1:
>
>gcSeekVal = employeeno
>calculate sum(activity.hours) to thisform._textbox1.value for activity.employeeno=gcSeekVal
>seek gcSeekVal &&this is just to keep pointer on employee clicked
>
>What obvious thing have I missed. (Tick, tick, tick, Y2K clock)
>
>Thanks in Advance,
>Sylvia

---

Sylvia,
When there is parent-child relation I prefer to sum once per parent rec change. Then sum is only affected by the field contributing it. So implementing this approach to your tables :

* Employee grid.afterrowcolchange
select sum(hours) from activity ;
 where employeeno = employee.employeeno ;
 into array aSum
thisform._textbox1.value = iif(type("aSum[1,1]") # "N", 0, aSum[1,1])

* Activity.grid.hourscolumn.gotfocus
this.tag = str(this.value)

* Activity.grid.hourscolumn.lostfocus
thisform._textbox1.value = ;
  thisform._textbox1.value - val(this.tag) + this.value

This has the advantage that you don't need to check record pointer movement and fast even with thousands of child records.
Cetin