What is Lookup Property Editor?
A lookup property editor refers to a dropdown list associates with a collection of objects, which will look like this:
Why does it behave differently under different situations?
If the lookup property’s data source has less than 50 records, all of these objects will be retrieved from the database immediately, as the snapshot shown above.
To optimize the performance, if the data source of the lookup property editor contains more than 50 records, none of these objects is retrieved, and the Search feature is available.
By using the search function, objects will be filtered with the given keywords and loaded into the list.
How do I change the default setting of the 50 Records limit, and set it to greater number when I use internal network and have a high performance server?
Open the Customization Centre from Tools->Customization Centre
Navigate to Options
Look for LookupSmallCollectionItemCount
Change this property’s value
Is it possible to force system to load all items regardless the objects count?
Yes it’s possible. In this example, I am going to change the loading behavior of the Debtor in Quotation Detail View.
Open the Customization Center, navigate to the view you want to customize.
Navigate to the property “Debtor”
Set the LookupEditorMode to “AllItems”
Save the changes and back to the main application, you will see the system will load all the debtors even it has more than 50 records.
There is also another option “AllItemsWithSearch”
Full Version: http://supportsystem.LiveHelpNow.net/resources/3203/How%20to%20change%20the%20Lookup%20Property's%20search%20behavior.pdf