Trigger to Insert New Data into Lookup Table

[pmcfarlain]

So I'm trying to make a trigger so that when new data is inserted/updated in my table it checks that the address doesn't match any existing addresses for that Customer and if not, it stores the address in a lookup table for easier inputting in the future. This is the trigger I set up but it isn't working. Anyone know a better way to do this?

[Flowers4Algernon]

Hi, you may wanna try this triggered action:

 

This triggered action would check if the inserted address is NOT IN your lookup table's address column and insert the record if it is not in the column.

[NiceDuck]

You may also try No exist operation.