Identifying identical values between two table

Jamie,

If this is a process to be run periodically, a Pipeline with a Search Step can easily compare the fields.

One way is to run when you add a record to the first table.

Step B will search Table 2

if there is no match a.tin= b.tin

then create a new record in Table 2