>Thanks, James. I am using a view to update the main table and the children tables are buffered tables. These updates are all happening inside a transaction.
>
>Evelyn

I think that you might have just answered your own question: have you checked all the logic for committing the transaction?