Customizing lookups

The structure of lookups is defined by settings that you configure in the Lookup Set form. This example shows two Lookup configurations.

  1. Define the query in the Query form. (See Configuring queries.) For this example, the name of the query is FORMULALOOK2\@. Here is the query text. 
    
SELECT [%%DBO]FsDesc('FSFORMULA', D.FORMULA_ID, [%LANGUAGE], DESCRIPTION)
AS DESCRIPTION, FORMULA_CODE, VERSION, CLASS, D.FORMULA_ID  
FROM FSFORMULA D, FSFORMULASETS S 
WHERE LOGICAL_DELETE = 0 AND TYPE_IND = 0 
AND DESCRIPTION LIKE [%%LIKECLAUSE] AND D.FORMULA_ID = S.FORMULA_ID AND S.SET_CODE=[%LAB] 
ORDER BY DESCRIPTION
  2. Configure the Lookup Set form.
    customizelookups