Table Management
-
Creating a Schema
To create a new database schema:In the Quick Access pane towards the left of the window, open Database Designer.Click the New Schema button located towards t...
-
Inserting a New Table
To create a table within the database: Go to the Tables tab and click Add Table - . Figure 1 - Adding a table to the database A new row appears in the tabl...
-
Editing the Table Contents
When you first create a table it will be empty and you will need to add the desired contents. In addition, existing tables can also be edited. You can add fu...
-
Table Properties
A schema can contain a number of tables, and these are listed on the Tables tab. Click on a Table ID number (blue text to the left of a table row - it turns ...
-
Generating the Table
Once the table properties are set up as required, the table must be generated. This adds the table to the database according to the properties you have set u...
-
Exporting the Table Contents
You may wish to modify the table contents outside of the database designer and upload the data back into the database designer afterwards. To export the tabl...
-
Adding a Relationship
In the Relations tab you specify the relationship between the tables; that is, which table is the "parent" of the currently selected table.Go to the Relation...
-
Table Lookup
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 ...