In this article
The Table Lookup Appearance option is only available for Table lookup / Hierarchy questions.
If in the Appearance field you select Table lookup, 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 Table Lookup fields
The question will then be presented to the respondent as an ordinary single question according to your settings in the Question Details page and the Properties sheet, and will retrieve the answer list dynamically from the table in your database schema. The answers will be listed in the same order as in the table in the database schema.
Note: Piping cannot be used in table lookup questions.
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.