Basically, lookup_1 is constantly changing, new rows are added and removed. If a new row is added to lookup_1 (ID will ALWAYS have a unique ID), the search will add it to the lookup_2. The problem is when row is removed from lookup_1, the above search will NOT remove that "old" row from lookup_2 that is NOT existing in inlookup_1 anymore. Example of the problem: 1. lookup_1 has been updated with 10 rows, above search runs and updates lookup_2 which now has 10 rows also. 2. When, a row is removed from lookup_1, now having 9 rows. Search will run and update lookup_2, which will have all 9 "new" rows from lookup_1, but +1 OLD row from previous lookup_1 version. Search is only appending new rows from lookup_1 to lookup_2, but not removing from lookup_2 if removed from lookup_1. Hope that explains it better 😕
... View more