Remove Automatic Query
Prevent automatic full table queries for lookup windows.
When opening a lookup window, an automatic query is performed. Especially for large tables, this can be a drain on performance. The easiest way to get rid of automatic queries is to remove the Startup Actions setting of Lookup Windows. This setting defaults to PerformQuery().
When to use
You can use this tip on three different levels:
•For the generic Lookup Window class, if you do not want automatic queries in lookup windows at all.
•For a specific Lookup superclass, if you do not want automatic queries in lookup windows for one table.
•For a specific lookup window, if you only do not want automatic queries for a specific lookup window.
To prevent automatic full table queries in lookup windows: