>>Can something like that be adapted to your situation?
>Okay, I tried to adapt this to my situation, and this is what I came up with:
>

>SELECT srvcid, UBILLDESC, stdntid, SUM(wrkRealCost) AS wrkRealCost, ;
>  C1, C4 ;
>  FROM BL731 WHERE wrkStatus<>ACTIVE ;
>  GROUP BY srvcid, C1, C4, UBILLDESC , stdntid ;
>  INTO CURSOR BL
>
>SELECT BL731
>INDEX ON srvcid + UBILLDESC + BINTOC(stdntid) + STR(C1) + STR(C4) TAG mainmix
<pre>
>SELECT BL       ---              remove this line

<pre>
>SET RELATION TO srvcid + UBILLDESC + BINTOC(stdntid) + STR(C1) + STR(C4) INTO BL731 IN BL
>

browse

Did you verify visually that your relation is correct?