BBritain
VIP Member
Hi Gurus,
I'm looking for the most efficient method of retrieving records that are in table Main, but not in table BoltOn. The tables have one common field (MCU). Both tables are pretty large and the number of records in Main but not in BoltOn is very small (probably less than .1%). This is being searched in a Form (probably Find/Browse) and grabbing ALL records in Main and using ER to check if they are in BoltOn (in order to exclude) will be prohibitive. Please suggest anything!
Regards,
Ben Again
I'm looking for the most efficient method of retrieving records that are in table Main, but not in table BoltOn. The tables have one common field (MCU). Both tables are pretty large and the number of records in Main but not in BoltOn is very small (probably less than .1%). This is being searched in a Form (probably Find/Browse) and grabbing ALL records in Main and using ER to check if they are in BoltOn (in order to exclude) will be prohibitive. Please suggest anything!
Regards,
Ben Again