OnLookup (Page fields) Trigger
Runs in place of the normal lookup features for the current page.
trigger OnLookup(TextString) begin ... end;
Text string entered into the text box and used as the lookup value.
- Fields on pages
There are three lookup options:
Default Lookup - The lookup into the table is performed without applying filters or other special parameters.
Field Lookup - You can define a lookup trigger on a field that will be used in place of the default lookup. For more information, see OnLookup (Fields) Trigger.
Text box Lookup - You can use this trigger to define a lookup based on the value of a text box. This value will be used in place of the default lookup or the field lookup.
For example, for the Customer Code field, a lookup into the Customer table is provided. If you want a lookup into another table or if you want to place a filter on the table before displaying the lookup, use this trigger.
If an error occurs in the trigger code, the lookup is canceled.
You can use this trigger to write to the database.
OnLookup is also a field trigger at the table level. The flow is different for this trigger. When a lookup is requested, the page field's OnLookup trigger is executed if it is defined in the field lookup or system default. If no control lookup trigger is defined, the OnLookup (Fields) Trigger (if defined) replaces the system default lookup .