Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ONE TO MANY FORM
Message
De
20/08/1997 16:47:21
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, États-Unis
 
 
À
20/08/1997 16:24:58
Nick Berryman
Computer Automation Technologies
Kennesaw, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00045959
Message ID:
00045972
Vues:
27
>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...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform