Pop-up Menus offer the end user a pop-up dialog window to choose from displayed values. However, filling the contents of the pop-up with too many values will increase the amount of time the user must search for their desired value, and will exhaust time when the dialog loads the available options.
There are several ways to avoid populating the pop-up menu with too many values:
| 1. | Use the "Distinct Value(s)" check box within the Pop-up Menu settings. |
| 2. | Issue a DIALOG command before the form is loaded to prompt the end user for data specific to the results of the pop-up menu. Using the input within the WHERE Clause settings of Pop-up Menu will minimize the number of records returned. |
| 3. | Add a dynamic WHERE Clause within the Pop-up Menu settings in order to prompt the user for a more specific result. |
Examples of dynamic WHERE Clauses:
Example 01:
-- Dynamic WHERE Clause (Company LIKE)
Message:
Enter First Few Characters of Company
WHERE Clause:
WHERE Company LIKE '&%' ORDER BY Company
Example 02:
-- Dynamic WHERE Clause (Company CONTAINS)
Message:
Enter Company Name:
WHERE Clause:
WHERE Company CONTAINS '&' ORDER BY Company
Example 03:
-- Dynamic WHERE Clause (CustState =)
Message:
Enter State:
WHERE Clause:
WHERE CustState = '&' ORDER BY Company
