CREATE TRIGGER SOMAddExtras
   ON M2MData01.dbo.SOitem
   AFTER INSERT
AS
SET  NOCOUNT ON

IF EXISTS (SELECT dbo.somast.fsono
             FROM    dbo.somast
                  INNER JOIN
                     inserted
                  ON dbo.somast.fsono = inserted.fsono
            WHERE somast.fstatus = 'Open')
   BEGIN
	 
      UPDATE SOM
         SET SOM.fprodcl = I.fprodcl,
             SOM.fpartno = I.fpartno,
             SOM.fgroup = I.fgroup
        FROM    [CheltonCustomizations].[dbo].[soMods] SOM
             INNER JOIN
                inserted I
             ON SOM.FSONO = I.FSONO AND SOM.FENUMBER = I.FENUMBER
   END
GO