Go to Record [First]
If [table1::field1 = table2::field2]
Go to Record [ Next ; exit after last]
Thank you so much for this; I can't believe I wasted so much time looking for such a simple, elegant solution!
I may have a similar problem as yours, but in my case I am only given a list one attribute and not the whole table, is it possible to search or compare the given list with the same attribute on table in FM solution.