[continued from previous message]   
      
   			Update dbo.Circuits   
   			set dbo.Circuits.Status = 1   
   			Where (dbo.Circuits.Status=3) AND (dbo.Circuits.SR_ID   
   				IN (Select i.id from inserted i inner join deleted d   
   					on i.id = d.id and i.EngineeringComplete_Act <>   
   d.EngineeringComplete_Act))   
   	End   
      
      
      
      
   Appreciate the help,   
      
   Eric   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)