>>Running VFP 9, SP 1.
>>My report has 2 detail bands. The first detail band prints the info about a part. The 2nd band prints two pictures showing the part. If there are three pictures then there are 2 records for the 2nd band.
>>
>>The first band works ok, the second detail band only prints the 1st record. I have confirmed that there are 2 records for the 2nd band in the table.
>>
>>Any ideas?
>
>assuming that Part and Picture are in two different table
>and Part table is related to Picture table
>
>you need to add SET SKIP TO (picture table) after SET RELATION command
>
>and you need to create a group on part and place the part info in the group band header and the picture in the detail band
Sharath, That was the fix. We only had the relation set. Been too long since we did anything but create one cursor to run a report from. Thanks.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn