In this article
The Hierarchy appearance option is only available for Table lookup / Hierarchy questions.
If in the Appearance field you select Hierarchy, the Answers area will then present a field to enable you to select a database schema. Once you have selected a schema, a new field will appear to enable you to select one of the tables in that schema.
Figure 1 - Example of the Hierarchy fields
If the list of schemas and/or hierarchies is extensive you can search for the required item(s). Start typing a character string into the field and the list will be filtered such that it only shows those items that include the character string somewhere in the name.
Note: Piping cannot be used in hierarchy questions.