Tables [dbo].[FORMS_DD]
When "Database fields" are added to a form, the list of available fields comes from this table.
NameData TypeMax Length (Bytes)NullabilityDescription
FieldIDint4NULL allowedKey to the FORMS_DD table
TableNamevarchar(50)50NULL allowedTable name the field pulls from
FieldNamevarchar(50)50NULL allowedColumn name the field pulls
DataTypevarchar(20)20NULL allowedType of database field (text, date, memo)
Lengthint4NULL allowedLength of database field
Decimalsint4NULL allowedIf using an int or numeric datatype, this is how many decimals
ObjTypeint4NULL allowedType of object
FieldDescriptionvarchar(50)50NULL allowedDisplay name of field for form builder