>Let's consider:
>

>BEGIN TRANSACTION
>update TableA && it triggers update tableB that has a trigger to update manager's forms
>END TRANSACTION

>
>What is going to happen and in what sequence?
>
>Also AFAIK you can not tell within trigger which fields you're updating. What if I'm interested only in one particular field update for TableA and don't want to raise any events if I'm updating other fields?

Hi Naomi,

I was probably unclear. The update to tableB doesn't happen WITHIN the transaction affecting TableA, but only AFTER the transaction to tableA has been committed:

Begin transaction
Update table A
End Transaction
Update table B && This is the event that the manager's app is watching. Once 
               && this event fires, you know that a change has been made
               && to tableA and committed.

If all you're interested is in a particular field in TableA, just grab the value as that value is now current (whether it was changed or not). Now, if you want to tell if the value changed, you need to add a mechanism to track that as well.

Hope this is clearer.

Alex