Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ONE TO MANY FORM
Message
From
20/08/1997 16:47:21
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, United States
 
 
To
20/08/1997 16:24:58
Nick Berryman
Computer Automation Technologies
Kennesaw, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00045959
Message ID:
00045972
Views:
29
>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 nField1
lnField2 is the numeris total for field nField2

HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform