• Hi Anthony,

    No the deleted table is not the ttask table.

    In trying to trouble shoot this myself I can get values for fields in the deleted table and put those into a table.

    However I can not be certain that only one row will be affected so can't read deleted table into a series of local variables and then write them into the audit table

    ttask does not have any deletions in this process

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx