>On a one to many form:
>How would I create a field do display the total of all child records for the parent record that you are currently on?
>
>Nick
Here's one way...
put this code in your navigation control method after the parent pointer has been moved
SELE Child
SUM 1, nField1, nField2 TO lnCount, lnField1, lnField2 ;
FOR Parent.key = Child.Key
SELE Parent
THISFORM.Refresh()
lnCount gives a count for the number of children
lnField1 is the numeris total for field
nField1lnField2 is the numeris total for field
nField2HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...