>i finally have a need for the new report features
>I have payee info in the group band, deductions in the detail band and now I added a second detailband with payments from another table
>

>SELECT ;
>	cc1.payee_id,;
>	IDNUM,;
>	PAYEETYPE,;
>	NAME1,;
>	.....
>        BenefitType,;
>	numDeductions,;
>	emplact.shortname AS dedtype,;
>	nvalue,;
>	effdate,;
>	enddate ;
>	FROM cc1;
>	LEFT JOIN emplact ON cc1.payee_id=emplact.payee_id ;
>	AND emplact.shortname IN ("GARNISH","OPMNT");
>	LEFT join claims ON cc1.BUSSEG_ID = claims.claim_id;
>	LEFT join statute ON claims.statute_ID = statute.statute_id;
>	INTO CURSOR ccPrint;
>	order BY 4,5,2
>
>
>	SET REPORTBEHAVIOR 90
>	SET RELATION TO payee_id INTO timesht && (payschedule comes from here)
>
>	SELECT ccPRINT
>	REPORT FORM reports\r_employee_list2 preview
>
>

>
>the report has info from ccPRINT in the group and detail bands
>and info from related timesht table in 2nd detail band
>
>
>the 2nd detailband does not show anything!
>
>Thanks
>
>
>Peter

I have not uses this until now, but:

- Have you set "Target alias expression " ?

- and

* is your relational schema ?
ccPRINT
   timesht 
      payschedule 

this require a nested detail band, and VFP9 doesn't support this feature.

i think you have to use an one level relation

* have you this relational schema
ccPRINT
   timesht 
   payschedule