>>>>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?
>
>yes, I stop the program right after this, then browse bl first and then bl731. bl731 only shows the record(s) that match the record bl is on at the time. I can change the record in bl and the record(s) change in bl731 when I click back on it.

May be the problem in our case that we may have more than one matching record? Or none of the records get updated?

Also I was wrong about removing the line. The SELECT BL is OK.