>>>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.