help again pls. I have a sql database with access for client gui. In it are two tables one table serves as the main form(Active table) the other as the subform(employeeDocs) they are related. I also have a termination table which a trigger that I created I created updates from the active table. Now I need to tell the trigger to delete these terminated records after updating the terminated table. heres my code
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'
how would i go about doing that?? I keep getting error messages