Lookup Combo Boxes, Lookup List Boxes and Lookup List Views are powerful controls to use in R:BASE forms for displaying records. However, filling the contents of the controls with too many records will decrease the speed in which the R:BASE form will load and refresh. It is also important to consider how many lookup controls are used on the form in relation to the number of records they will retrieve.
There are several ways to avoid populating Lookup controls with a great number of records:
| 1. | Use the "Display Distinct Value(s)" check box within the object's settings. |
| 2. | Issue a DIALOG command before the form is loaded to prompt the end user for data specific to the results of the Lookup. Using the input within the Lookup's WHERE Clause will minimize the number of records returned. |
| 3. | Issue a DIALOG command before the form is loaded to prompt the end user for data specific to the results of the Lookup. Then, create a VIEW with resulting values and use the Lookup to display the resulting value(s). |
