Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One-to-many Problem
Message
 
À
12/09/1998 16:14:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00135626
Message ID:
00135862
Vues:
11
>>
>>Lincoln,
>>Have you considered starting over with a single cursor that contains ALL your data from both tables? Then you group on your 'parent' value and show the 'child' values in the Detail band.
>>
>>HTH
>>Barbara
>
>I am making progress! Now the only glitch is my child values are alternating instead of being grouped (ChildA-1,ChildB-1,ChildC-1,ChildA-2,ChildB-2,etc. instead of ChildA-1,ChildA-2,ChildA-3,ChildB-1,ChildB-2,etc.), but at least I'm back to only one page.
>--lincoln

Lincoln, if you are using a cursor for the child records (as in my other reply) check that you have them listed in the ORDER BY clause. If you're using linked tables then you'll have to do it with the indexes on the linking fields.

Barbara
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform