>Hi All,
>
>I have a form and contain two tables in the DataEnvironment (Parent/Child relationship). The parent form I want to sum all the total from a field in the child table and display the grand total in the parent form. Is a way to write a select statement to sum the total inside the DataEnvironment? Is there any method of doing this task? Any sugguest or help is appreciated. Thanks in advance.


I would do the select in the form.load() as it occurs before any controls on the form are created.

In the dataenvironment opentables() method you could put something like :

IF DODEFAULT()
SELECT .......
INTO CURSOR ......

NODEFAULT
ENDIF