CREATE TRIGGER [dbo].[Untitled]
ON [dbo].[tbl_lab_information_AttachFile]
WITH EXECUTE AS CALLER
FOR INSERT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
	DECLARE @LN NVARCHAR(20);
	SET @LN = (SELECT IATF_LN FROM INSERTED);

	UPDATE [LAB_DB].[dbo].[tbl_lab_information_Request]
	SET [IREQ_IS_ATTACH_FILE] = 'Y'
	WHERE [IREQ_LN] = @LN
END