Home > Data Manager > Form From Table

Form From Table

Form Master 2008 can create a Form from the Fields in an External Table. Using this function will overwrite any existing form for this Module.

• Data Source Table List: The List of Tables from the Default DNN or User Specified Database

 The Grid Columns:

• Column: The name of the SQL Table Column
• Type: The Data Type of the Table Column
• Length: The allowable Length of data for the Table Column. This is useful primarily for Text type data and does not apply to Integer types or Boolean values and is shown for seting up field validation. 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, and is shown for seting up field validation 
• Nullable: If a column is not Nullable then the Requred Checkbox should be checked.
• Form Field: The Form Field name which will be specified in the Field Name textbox in Common Options (this name must not contain spaces or special characters)

The Process:

1. Select the "Create Form From Table" Radio Button
2. Select the Field Type
3. Enter a Form Field Name or use the suppled Name
4. Check if the Field will have a Reqired Field Validator added
5. Click the "Commit Operation" Button