>>>>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.
If it's not broken, fix it until it is.
My Blog