In this article
The tables or hierarchies can be used in single questions in the Survey. In a single question's Properties page, go to the Answers drop-down list and choose between Normal answer list, Table lookup and Hierarchy lookup - .
Figure 1 - Selecting the desired Answers property
If you select Normal answer list, the answer list is inserted as usual in the “Answers” tab. This option is selected by default for the answer list, and results in a "standard" list of answers from which the respondent can make the desired selection(s).
Note: If Hierarchy Lookup is selected, the order in which answers are displayed in the hierarchy will adhere to the Answer List Display Order property. If "Alphabetically sorted" is selected, the answers will be sorted alphabetically. However by default the answers will be displayed in the order in which they appear in the Database Designer.
If you select Table lookup, the “Answers” tab will present an interface to enable you to select a database schema and one of the tables in that schema - , as shown in the example below.
Figure 2 - Selecting the table for "Table lookup"
The question will then be presented as an ordinary single question according to your settings in 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 designer.