I am looking for a trigger that will update my table after an Insert.
Table to run trigger on "TEMP"
When a record is entered I want to take the Field "MTSS_NAME" and go to the table called "ANALYST"
Analyst Table Contains the Fields "EMAIL" and "ManagerName"
Find all of the Email with the "ManagerName = to Mtss_Name" and create a string separated with a ";" and update the table "TEMP" with that string into the field "DistrictDL"
Can someone help Please.