Suppose your organization wants to conduct an employee survey. You determine that you do not want respondents to see information that other respondents have entered on the Form. However, you do want all Form data to be stored in a database table because you plan to generate a LiveReport that evaluates and presents the data.

To set up a survey Form:

  1. Create a Form Template that contains the text, fields, and buttons that you want to appear on the survey.

  2. Click the Form Template's Functions icon and select Manage Relational Table. Specify the following settings:

    • In the SQL Table Name box, type a name for the survey data table.

    • In the Create SQL Table list, click Create database table using name above. For more information about defining a Form Template, see Defining a Form Template.

  3. Add a Form based on the Form Template. When you define the Form, use the following settings:

    • In the Revision Mechanism list, click <None>.

    • In the Submission Mechanism list, click SQL Table.

    For more information about defining Forms, see Defining a Form.

Using the Survey Example

As two or more users, complete the survey Form and click the Form's Submit button. Note that you cannot access the information that another user has submitted. When all surveys have been returned, you create and run a LiveReport that summarizes and evaluates the data.

For information related to this procedure, see Revision and Submission Mechanism Examples.