Touchworks 25.2
[dbo].[FORMS_DD]
When "Database fields" are added to a form, the list of available fields comes from this table.
| Name | Data Type | Max Length (Bytes) | Nullability | Description |
|---|---|---|---|---|
| FieldID | int | 4 | NULL allowed | Key to the FORMS_DD table |
| TableName | varchar(50) | 50 | NULL allowed | Table name the field pulls from |
| FieldName | varchar(50) | 50 | NULL allowed | Column name the field pulls |
| DataType | varchar(20) | 20 | NULL allowed | Type of database field (text, date, memo) |
| Length | int | 4 | NULL allowed | Length of database field |
| Decimals | int | 4 | NULL allowed | If using an int or numeric datatype, this is how many decimals |
| ObjType | int | 4 | NULL allowed | Type of object |
| FieldDescription | varchar(50) | 50 | NULL allowed | Display name of field for form builder |