I have two different tables associated via a keyfield NUMBER. I want to create an alert that goes on when new values are inserted in NUMBER.Table1 (in this case, new values being added) that match with any value contained in NUMBER.Table2. The idea is that the alert would show the new value added that matchs with a value in Table 2 AND also shows other dimension associated with the new value added in Table 1.
Is that possible for the alerting function? I have been trying to solve this, but it seems to be difficult to assess within the idea of the Alerting, but maybe I'm missing something.