Attributes are linked to form controls according to their data type. The table below provides a list of form controls and the compatible data types that can be used with them.
| Control | Data Type |
|---|---|
| Checkbox | Bit |
| Comment | Unique Identifier (in case of communication with a second entity) |
| Date/Time Picker | Date, DateTime, DateTime2 |
| File Attachment | NVarChar (size: 100, according to the number of attachable files), NVarChar_Max, VarChar, VarChar_Max |
| Free Draw | VarBinary, VarBinary_Max. |
| Gantt Chart | Unique Identifier (in case of communication with a second entity) |
| Grid | Unique Identifier. It can be used to bind different fields together. The data type may or may not be same for each field in the list. |
| Nested Form Link | Unique Identifier (in case of communication with a second entity) |
| Numeric Textbox | Big Int, Decimal, Float, Int, Money, Numeric, Small Int, Small Money, Tiny Int. |
| Radio-Button List | String Data Types (such as Char, NChar, NText, NVarChar, or Text), Numeric Data Types (such as Decimal, Float, Int, Numeric, or Real) , and the Bit (Boolean) data type. |
| Textbox (Single-Line, Multi-Line, Password) / Rich Textbox | Char (Char or NChar), VarChar (VarChar or VarChar_Max), NVarChar (NVarChar or NVarChar_Max). |
| Time Duration | DateTime |
| Tree | Unique Identifier (in case of communication with a second entity) |
| User Picture | VarChar (size: 36, in the case of communication with the MercUsers entity) |
| User Signature | VarChar (size: 36, in the case of communication with the MercUsers entity) |