>>Oops on the last reply...OK....enable Table buffering on Table_3 and perform your INSERTS before entering the transaction. Once in the TRANSACTION, use TABLEUPDATE() to commit changes to Table_3.
>
>***
>
>OK, i allready tried to do it this way, but in that case, NO records were indexed at all. But maybe the core is somewhere else. There are lots of related settings (i mean the SET ... commands), that may affect the VFP behaviour in these situations.
>Is there some further documentation about internal dependencies between "SETtings" and other data-processing commands ?
>
>Thanks and help me if you can ...
Wait a second....Go back to the original way you were doing it and check that the following is true.
SET EXCLUSIVE OFF
SET MULTILOCKS ON
Post back and tell me what they were and if a change was needed and if it helped.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05