>>>I have about 1000 records in a table ordered by the mainkey field. i.e.
>>>
>>>

>>>Mainkey
>>>---------
>>>Neil01    Cutting
>>>Neil02    Costing
>>>Neil02    Made
>>>Neil02    Sent
>>>

>>>
>>>everytime the mainkey changes when I scan down the table I want to append a record in another table with the value of mainkey.
>>>
>>>How can i do this easily??
>>

>>SELECT YourTable
>>lc_Mainkey = YourTable.Mainkey
>>SCAN
>>    IF lc_Mainkey # YourTable.Mainkey
>>       INSERT INTO othertable ....
>>       lc_Mainkey = YourTable.Mainkey
>>    ENDIF
>>    ...
>>ENDSCAN
>>

>
>Vlad,
>A small correction:
>

>lc_Mainkey = ''
>SCAN
>    IF !(m.lc_Mainkey == YourTable.Mainkey)
>

Cetin

I agree with the correction.