Getting Started #
The Lookup form appears in the following scenarios.
- When you F4 or double-click in a parameter field.
- When you F4 in a table cell like Job, GLAcct, Vendor, etc.
- When you are modifying the Where part of a Table/Report and want to hard code values instead of adding a parameter.
Fields #
- Column
- Lists the column names from above.
- The selected column will be used by the Search field for filtering.
- Search
- Filters the lookup list based on what is entered.
- Wildcards exist automatically on both sides of the Search field value.
Buttons #
- Clear
- Clears the Search field to show all lookup list records.
- Save
- Saves the selected value(s) to the field that triggered the lookup.
- Add To
- Adds the selected value(s) to existing values in the field that triggered the lookup.
- Split
- Saves the selected value(s) to the field that triggered the lookup.
- Surrounds the values in SPLIT() which will create one worksheet per value.
- Cancel
- This closes the form.