Map Existing Table

Form Master 2008 can map Form Fields to an Existing SQL Table.

Connection String: The Connection string to the Data Resource. Leave blank to use the Default System Connection String. If defining a Connection string, it must be set before any Mappings are started since Mappings are based on what Tables exist in the Database.
Data Source Table List: The List of Tables from the Default DNN or User Specified Database
Existing Table Fields: The Grid shows the Fields in the Selected Table and allows for Mapping to Form Master Created Fields.
Form Field: List of Fields Defined in the Form used for Mapping to External Table Fields.

The Grid Columns:

Column: The name of the Table Column
Type: The Data Type of the Table Column
Length: The allowable Length of data for the Column. This is useful primarily for Text type data and does not apply to Integer types or Boolean values. A discussion of SQL Data Types is beyond the scope of this User Guide.
Prec & Scale: These are for use with Numeric & Decimal Data Types
Nullable: If a column is not Nullable then a Requred Field Validator will need to be included on the Form.
Form Field: Initially empty, will show Form Field names as they are mapped to the Table.

The Process:

Select the "Map Existing Table" Radio Button
Optionally Specify a Connection String
Select a Table to map to in the "Data Source Table List" dropdown list. Note: the selected table must have an Auto Increment Identy Column
Select a Form Field Radio Button from the "Form Fields" list
Click on the "Map" link on the Table Column to be mapped to the Form Field. If a mistake is made the UnMap link can be used to remove the mapping.
When all Form Fields have been mapped, click the "Commit Operation" button.