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