The toolbar of the Designer dialog box provides distinct commands for creating and editing forms. The toolbar icons are grouped according to their function.
Click an icon to add a control to the form, as shown in the following table:
Icon |
Description |
Note:
The controls TEXTBOX, CHECKBOX, COMBOBOX, COLORBOX, PICTUREBOX and PICTURECOMBOBOX refer to a database attribute. For each attribute, you can apply one appropriate control. If all database attributes have one of these controls, no further control of this type can be created. The message "All Attributes Have A Control! Would You Like To Replace An Existing Control ?" indicates that there are no attributes without a control in the current form. Click Yes to replace the control. In the Select Control To Be Replaced list you can select the attribute. |
|
Controls, used to show a text box, referencing a value |
|
Property TextBox Class name: TEXTBOX Adds a text box to show the content of the database attribute. Use a text box to show the content of a database attribute. The Message: All Attributes Have A Control ! means: In the current form, there are no attributes remaining without control. |
|
Read-Only SQL TextBox Class name: SQLLABEL Adds an SQL Label. Use this to show the result of an SQL query. You can define a select statement to query any information. The result is shown in the form, but cannot be edited. Example: Use SQL label to calculate the total area of all related parcels. |
|
Editable SQL TextBox Class name: SQLTEXTBOX Adds an SQLTextBox: Use this to show the result of an SQL query, for example, to show the area which is stored in a different table. The result can be edited and the value is saved (update). Use this type of control only if you query a single attribute. |
|
Class name: FORMULA Adds a formula to show the result of a calculation using the database attributes. Use this to calculate values. You can use all database attributes and all mathematical expressions (VB .NET code). |
|
Controls that open an editable form, showing all properties of a referenced feature or set of features. |
|
Basic Form Launcher Class name: REFERENCE Adds a Reference. Use this to show data related to the current record. Reference controls are created for all relations that point to the current table, for example, the relation to the label feature class. Note:
This control is set by default, according to TB_RELATIONS |
|
FID Form Launcher Class name: FIDREFERENCE Adds a FID-Reference to open a form that belongs to a certain FID (dynamic relation, multi-relation). An FID Reference is not linked to a database attribute of the current table. Use FID References to show data with a special FID. |
|
SQL Form Launcher Class name: COMLEXREFERENCE Adds a ComplexReference to create references using complex SQL statements, for example to open a form of another table. A Complex Reference is not linked to a database attribute of the current table. Use this to open the form of another table with a filter. You can define this filter with complex SQL statements. |
|
Advanced Form Launcher Class name: MULTIREFERENCE Similar to the Reference control, you can use multi-relations. |
|
Combo boxes |
|
Basic Combo Box. Class name: COMBOBOX Adds a combo box that enables acquisition through a dropdown list. A combo box is always linked to a database attribute. Use this control to select your entry through a combo box from a domain table (*_TBD) or any other related table. |
|
Color Combo Box. Class name: COLORBOX Adds a color combo box that can be used to select a color from a list. |
|
Advanced Combo Box. Class name: MASTERBOX Adds an advanced combo box (master box). The master box control is similar to an add-on to the combo box control. Use this control to define one or more filters (pre-selections) for a combo box. For example, to enter a street name, you define a filter for the city. In the form, the master box looks like a combo box. |
|
Picture ComboBox Class name: PICTURECOMBOBOX Provides picture file names in a list box. |
|
|
Model Selector Class name: MODELBOX Adds a control for acquisition of model driven attributes. See also Data Model: Model Tables. |
Linkers |
|
Document Linker Class name: DOCUMENTMANAGER Opens the document manager and shows whether any documents are available. |
|
Picture Linker Class name: PICTUREBOX Displays record-related pictures. |
|
FID Linker Class name: FIDBUTTON Adds an FID button that can be used to select a feature in the map and fill an attribute with this value (data acquisition). |
|
Programmable controls |
|
Script-Programmable Control Class name: SCRIPTBUTTON Inserts a control that is programmed using VB script. |
|
API-Programmable Control Class name: APICONTROL Inserts a control that is programmed as a DLL. |
|
Static content |
|
Static Text Class name: LABEL Adds a label. Use this to write any text, notes, or remarks in the form. |
|
Static Picture Box Class name: STATICPICTURE Adds a StaticPicture: Use this to position a picture in the form, for example, a company logo. |
|
Horizontal Line Class name: LINE Draws a line. Use this to paint horizontal or vertical lines into the form. |
|
Other controls |
|
Coordinates Editor Class name: GEOMETRY Adds a Geometry control to show coordinates and to enable edition of coordinates. Use this to show coordinates (Y, X, Z) in the form. |
|
Checkbox Class name: CHECKBOX Adds a Yes/No CheckBox. A check box is always linked to a database attribute. Use this control to show the content of a database attribute which can only be 1 or 0, respectively Yes/No, or Open/Closed. A check box control is assigned to database attributes which are declared as num (1). |
|
|
Feature Highlighter Class name: HIGHLIGHTBUTTON Highlights a feature in the map. |