If u have dependency in 2 table and Change in I table requires a Changes in other Apply trigger to table I which will make Changes in II one
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [<Trigger Name>]
ON [dbo].[<Table name where Change Occurs>]
FOR INSERT
AS
DECLARE @Inserted_ID INT
BEGIN
SET @InsertedID = (SELECT FK_ID FROM INSERTED)
Update TrnTarget
SET testColName= testColName+1
WHERE FK_ID = @Inserted_ID
END