Getting Column Totals from Grid 2

[taysys]

I am using VFP7, Codemine v7, Windows 2000.

I have a form where I have two related grids. The parent selects related child records. I need to total the "amount" columns in the child for the user to view. I have tried different events that fire from the parent, but either I don't get the correct numbers or it messes up the child display.

Where is the best event to perform a column totaling routine in a grid?

Thanks...

Bob Taylor

 

[Mike Gagnon]

Create an SQL statement into a cursor, based on the order number.
Create a textbox (call it GridTotal) and place it just below your grid.
put this code in the grid.Refresh()

LOCAL lcCustno
STORE THISFORM.Custno to lcCustno
SELECT sum(soldamount) as grTot FROM working WHERE working.cusno = lcCustno INTO CURSOR mycursor
thisform.gridtotal.value = myCursor.grTot

 

[taysys]

Finally had a chance to work on this. Works great and is fast. Good work... Thanks.