great work Carl.

works fine.

Thank you very much

JK

first of all thank you Carl, i tried your code but couldn't update eny row!

sorry a mistake in my code

here again my way but with error message :

No row was...

Hello again,

and thanks for response

here my Idea:

CREATE TABLE [dbo].[Team](

[ID] [int] IDENTITY(1,1) NOT NULL,

[AssoID] [int] NULL,

Task [nvarchar](50) NULL,

Manager [nvarchar](50) NULL

) ON [PRIMARY]

GO

CREATE TRIGGER trig_updateM

ON Team

FOR UPDATE

AS

IF UPDATE(Manager)

BEGIN

declare @TID INT

declare @AsID...