I have a base with two tables/tabs. Table 1 with contacts incl. email addresses. Table 2 with email addresses. I would like to compare and if possible mark the record in table 1 when the two email addresses match.
I’ve created both link and lookup fields but can’t make it work. Link fields are not filled out with data from table 2.
Any ideas how to compare fields in two tables?