>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

Silvia, I usually use the functions like this one for getting the sums:

FUNCTION sum_activity_hours
LPARAMETER lcEmployeeno
LOCAL laSum[1]
store 0 to laSum[1]
SELECT SUM(activity.hours) FROM activity ;
WHERE activity.employeeno = lcEmployeeno ;
INTO array laSum
RETURN laSum[1]
ENDFUNC

HTH,

Nick