• Single-Line Text Field is used to store single line text.
• Password Field is used to store single line text, all characters are shown as "*" characters.
• Numerical Field is used to store numerals.
• Mathematical Field is used to store formulas and numerals. Using standard mathematical constructions, you can set a formula, according to which the necessary data will be calculated automatically, e.g. [Field C]=[Field A]+[Field B]. More information...
• Date Field is used to store dates. In the database you can use the calendar to set the field data.
• Time field is used to store time data.

Misc. Data Elements (from left to right)

This set contains the elements that store the data of irregular types, e.g. images or multiline text:

• Drop-down List is used to select one of many values in a database.
• Multiline Text is used to store multi-line text.
• Image is used to store images. Image can be stored in various formats (bmp, jpeg, gif, ico).
• Flag is used to store Boolean values (yes or no).
• Multi-select Field is used to select one or more values in a list of existing ones.
• Record UID Number. This field is filled in automatically during the new record creation and contains a serial number of the created record. For the first consistently created records it will be the 1,2,3,4, etc. numbers. The field has the following parameters: Current ID - contains the number to be assigned to the new record. With the help of this field you can begin the records numbering from any number.

Static Elements (from left to right)

This set contains the elements that store no data and are used to ease working with the form.

• Label (doesn't store data) is used to display static information, such as field captions. Also you can use the element as a separator.
• Simple Button (doesn't store data). The buttons are used to automate various operations with the database (e.g. a button that creates a new record or increases the field value by one). To define the script to be executed by the button use Script Designer... To check the operability of the button switch from the editing mode to the database mode. Know more about scripts...
• Text Button (doesn't store data). Though this element seems to be the same as a simple text, it stores no information and its behavior is similar to a regular button. Select this element in the database mode, type in the text and press Enter to execute the script and transfer the information entered in this field to the first input dialog. For more information see section Text Button.
• Static Shape (doesn't store data). This item allows adding simple geometric figures to form for grouping other items.
• Static Image (doesn't store data). This item is used for displaying an image on the form.

Relational Data Elements (from left to right)

This set contains elements that allow setting relations between records and combine records in groups, e.g. books with authors or orders with clients.

• E-mail Field is used to store e-mail addresses.
• URL Field is used to store URL addresses and shortcuts to local files.
• Many-to-Many Relational Field is used to build relations between records groups of different types (e.g. records group Books with records group Authors, or Products with Clients). See the Relational Elements section for more information.
• Simple Relational Field is used to create a link to another record. See the Relational Elements section for more information.
• Relational Lookup Field is used to get additional information from the related record. See the Relational Elements section for more information.
• Link To Folder field is used to keep folder link in the database. For example, if there is a project database, it is convenient to use this field in the form, describing the project, to keep a link to the folder with all the information on the project. Folder ID placed in this field can be used in formulas and scripts.
  Note: A Windows folder link cannot be kept in this field. Instead use URL Field.

Working in the Editor Area

The Editor area is used to select elements and change their size and positioning. Left-click on an element to select it. The selected element is highlighted with eight squares around it:

Drag one of the black squares to change the element size. Drag the mouse while holding the left button down to select multiple elements (the same way you select files in Windows):

Element Properties

Use the property window in the upper part of the window to change the properties of the selected element:

Properties common to all elements can be accessed by clicking elements with the right mouse button:

For each element, properties are categorized into the following groups:

• Individual Properties - properties dependent on the element type. For example, list of values for a list or script for a button.
• Font/Color/Border - allows you to modify common properties of the elements, such as font or color.
• Tab Order - this group sets the tab order, that is, the sequence of input focus switching with the Tab button.
• Layout (for elements) -  this group sets the element behavior when the size of a form changes.
• Layout (for forms) - this group sets the from position in the database window.
• Sheet (for elements) - this group allows you to define on which sheets of the form this element will be displayed.
• Sheets (for forms) - this group allows is used to add a new sheet to a form, delete an existing sheet or set its properties.
• Scripts and Behaviour. On this tab you can change element's behaviour on different actions of the user (on mouse-click, on changing the value, etc.), or assign scripts.
• Edit and Visibility - is the tab, where you can determine conditions, in which the element shall be shown in the form, and conditions, in which the user will be able to change its value. These rules are determined with the help of Rule Wizard.

Layout Property

This property is used only when the position property of a form is set to "fit to window". When this option is selected, changing the application window size makes the form resize to fit the window. You have to set the behavior for all of the elements of the form using the Layout properties pane. The following figure shows a sample element layout schema.

The light-blue field represents the element, while the texts on its sides allow setting the layout options for the following element properties: width and height; left, right, top and bottom margins. Having the FIXED option set for some property, this property remains unchanged regardless of the form size. On the other hand, setting the float option for some property makes the property value vary according to the form size. Please note that you cannot set all the three position properties (vertical or horizontal extent and margins) to FIXED.

For example, let us consider how the width property of the element affects its extent having the left margin fixed and the right margin floating, when the size of the form changes.

Case A illustrates the element clipped due to the form size reduction. Case B shows that the element resized according to the form size has changed: shrank to the form size reduction and increased to the form size extension.

According to the layout rules, the left margin has not changed while the right margin varied in all cases.

Combining elements with various positioning properties in a single form allows gaining the optimal use of the form surface, regardless of the window size. You may consider sample layouts in the example file.