If the recordsource of the child is a table, then a SQL-Select would work. Otherwise, the old Calculate Sum To command needs to be used.



>>I have a grid which the user can add records to a child table. Does VFP have a method for calculations on columns and/or rows. I would like to sum a numeric column without having to access the child table. Any help is greatly appreciated.
>>
>
>No method so far. I would suggest a custom method be created and do the calculation by SELECT-SQL to make it independent with the source table, thus, no direct access on the data and so record pointer will not change. The Method is actually a wish list of mine on the upcoming version releases because PB Data Window is supporting that feature.