Trigger

[Pingzinggolf]

I am trying to build a trigger and I am hitting a road block.

 When a record is inserted into the table... use the value for "#inserted.email" and look in another table called "CM_Contacts" and see if there is a record with that email address.

If there is a record send email to person A

If not then send email to person B

As the code stands now I am only getting the NOT found part even after I put a email address in from the CM_Contats table.

 

[TellMeWhy]

1 hour ago, Pingzinggolf said:

I am trying to build a trigger and I am hitting a road block.

 When a record is inserted into the table... use the value for "#inserted.email" and look in another table called "CM_Contacts" and see if there is a record with that email address.

If there is a record send email to person A

If not then send email to person B

As the code stands now I am only getting the NOT found part even after I put a email address in from the CM_Contats table.

 

Try this, basically check if the email exists in the email column of the other table, WHERE (email column of that table is equal to email column of #inserted)