Sample SQL menu

Suppose your SQL menu uses this query:

And the query returns the results shown in the following figure.

Results returned from the sample SQL query
 (Click the image to expand it.)

Each column has a corresponding numerical index:

• 1 corresponds to the BUG_ID column
• 2 to the FIRST_NAME column
• 3 to the TECHNCN column

Entering 2 into the Label Index List field creates a menu with the contents of the FIRST_NAME column as its menu items (see the following figure).

Menu created by the sample SQL query
 (Click the image to expand it.)



Entering 1 into the Value Index field inserts values from the BUG_ID column into the field. For example, if a user selects John from the menu, the BUG_ID value associated with John is entered into the field (see the following figure).

Field value if Value Index is set to 1 in sample SQL menu
 (Click the image to expand it.)



Entering 3 into the Value Index field inserts values from the TECHNCN column into the field (see the following figure).

Field value if Value Index is set to 3 in sample SQL menu
 (Click the image to expand it.)



Entering 2,3 into the Label Index List field creates a hierarchical menu (see the following figure).

Hierarchical SQL menu
 (Click the image to expand it.)