>Hi Craig,
>
>Got a fair bit of it working...I have hit a bit of a snag though in that trying to suppress the repeated values won't give me what I need. Data should look something like this for one of the child tables.
>
>(App #1)
>Sun Life Premium: $800,000.00 Date: Dec 15/06
> (indent) CasualtyCo1_Name Funded: $400,000.00
>Sun Life Premium: $800,000.00 Date: Dec 15/06 (<-- suppress this info)
> (indent) CasualtyCo2_Name Funded: $400,000.00
>
>(App #2)
>Sun Life Premium: $250,000.00 Date: Dec 15/06
> (indent) CasualtyCo3_Name Funded: $100,000.00
>Sun Life Premium: $250,000.00 Date: Dec 15/06 (<-- suppress this info)
> (indent) CasualtyCo3_Name Funded: $150,000.00
>
>So you see I cannot just put a "supress repeated values" because sometimes the info repeats and I want it to print and sometimes not. Normally I would have grouped on App_ID and had the info print when the App_ID changes. But it seems like grouping only applies to the primary (driving) cursor.
>
>I wonder if I have to somehow set some flag var to track when I have changed App_ID's within the child grouping and use that in the print when...
You can. You need to set a report variable, say lnAppId. You can then evaluate _vfp.DoCmd("lnAppId=apps.appnumber") in group header, then use lnAppId=apps.appnumber as your PrintWhen expression. Or choose any other good time to set this variable.