• Just a wild idea, but when writing triggers I tend to be rather specific in specifying when they fire for example:

    Create trigger orders_update_inventory on orders

    for update

    As I said a wild idea, - but you might want to give it a test run.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]