what if I took this trigger and based it on a view rather then a table
CREATE TRIGGER TerminationUpdateTrigger ON EmployeeGamingLicense
INSERT INTO TERMINATION(Status,[TM #],LastName, FirstName, [SocialSecurityNumber], DateHired, Title)
SELECT STATUS, [TM#], LASTNAME, FIRSTNAME, [SSN#], HIREDATE, JOBTITLE
WHERE STATUS = 'TERMINATED'
CREATE VIEW dbo.Update_Terminations
SELECT STATUS, TM#, LASTNAME, FIRSTNAME, SSN#, HIREDATE,
WHERE (STATUS = N'TERMINATED')
Base the Trigger on this View rather then on the Table itself????