Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One-to-many Problem
Message
 
To
12/09/1998 16:14:57
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00135626
Message ID:
00135862
Views:
10
>>
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform