AnsweredAssumed Answered

What's the fastest way to identify a non-matching record?

Question asked by filemakercowboy on Nov 2, 2017
Latest reply on Nov 10, 2017 by beverly

Here's the scenario:


Table A has 1,000,000 records

Table B has 1,000,001 records


In this scenario, we know that all 1,000,000 records in table A match (by primary key) 1,000,000 records in Table B.


What's the fastest way to identify that 1 extra record in Table B?


So far, I'm using a summary list field in Table A to gather all of the primary keys, then setting a global multikey field in table C, and using GTRR from there to table B. Is there a faster method?