Custom lookup to present Index Keyword History

From Support

Give the user a pick list of the values that already exist for an index key

The example for setting up the index keyword history list is as in the following image. In the LSSQLSTM field, the “and keyword1 <> ‘ ‘” is optional but keeps out the blank value. In this example note the following:

• The value in LSDOCTYPE must match the value after the “=” in LSSQLSTM
• USERKEYn matches KEYWORDn

The benefits of this example include that the users can still enter free text in the browser - they are not limited as in the dropdown lookup lists - and the list is searchable.