The text is not case-sensitive. For example, if you enter "abc," the lookup will search for "ABC."
The Lookup dialog displays as a popup. Use it to look up a value for a specific field. You can launch Lookup by clicking the button next to the field. You can customize the background color.
When the Lookup dialog displays, it shows all records for the field that was used for the lookup. Use this group box to filter the rows or sort them in a different order.
The options in this drop-down box depend on the application and the field being looked up. Select the field by which you wish to see the result data filtered and sorted.
Enter text here to filter the result data. If you enter part of the field, Lookup will find all records that begin with the entered value.
|
|
The text is not case-sensitive. For example, if you enter "abc," the lookup will search for "ABC."
|
Use the Execute button to perform the lookup based on the supplied filters. The results display in the table grid.
Select the row that you wish to use for your value by clicking on the button to the left of the row. Then click OK to import the selected row back to the application where the lookup was started.
Use the Cancel button to return to the application where the lookup was started.
The More button displays if the number of records found during the lookup exceeds the number of rows that can be displayed in a Lookup. You can set the maximum number of rows in the Max Lookup Rows field in the General Options tab of the General Configuration screen.