Some users may have permission to update the data in a survey. The columns that can be updated for a survey are defined here. Enditable fields are added by clicking the Add Data Update Columns button and selecting the columns from the list.


The grid showing the list of updateable columns is editable. .  



Parameter Column Names

Parameter Column Explanation

Actual column name

Some of the columns in the view may have different names to the columns in the underlying table. Select the actual column name in the updateable table

Lookup Table Name

The underlaying table may contain a foreign key relation to a lookup table. Select the name of that table here. This will cause this field to be a drop down list in the editing sections of the application, and will maintain data integrity

Lookup ID Column Name

Select the column name of the foreign key in the look up table

Lookup Display Column Name

Select the column name of the data to be displayed in the editing grid.

Enabled

If this is set to true, this field will be editable.

Created with the Personal Edition of HelpNDoc: Write eBooks for the Kindle