Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Common Properties of Fields

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Common Properties of Fields


This section describes properties of fields common for all types of fields. The window with field properties is located at the top part of the program window and has 9 tabs:

  1. Individual Properties - properties specific for different types of fields.
  2. Font/Color/Border - allows you to modify common properties of the elements, such as font or color.
  3. Layout - this tab sets the element behavior when the size of a form changes.
  4. Sheets - this tab allows you to define on which sheets of the form this element will be displayed.
  5. Tab Order - this group sets the tab order, that is, the sequence of input focus switched with the Tab key.
  6. Pop-up Text - on this tab you can specify a text that will be popupped if you hold the mouse cursor on a field. For a form this option is replaced with "Pop-up menu" that allows to create custom menu items in the standard "Record" popup menu.
  7. Scripts and Behaviour on this tab you can change elements behaviour on different user actions (on mouse click, on changing the value, etc.), or assign scripts.
  8. Edit and Visibility - on this tab 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.
  9. System - on this tab you set mandatory and unique fileld properties.


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 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. If the FIXED option is 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 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.

Scripts and Behaviour

On this tab you can change elements behaviour on different user actions (on mouse click, on changing the value, etc.), or assign scripts.

Actions can vary depending on the type of fields, but usually you can specify the reaction of the element to the following action:

  • On edit - script performed at manual editing of the field value. The script will not be performed if the field value was changed from the script, for example, using the "Apply Text Formula to a Field" action.
  • On left button click - action performed at clicking the field.
  • On right button click - action performed at right-clicking the field.
  • On double click - action performed at double-clicking the field.
  • On "Enter" key - action performed at pressing the "Enter" key when the field is active (only for simple text fields).

More information about events you can find in the "Events and Predifined Variables" chapter.

Scripts selected for these events can be called from other scripts using the "Execute field's script" action.

Edit and Visibility

On this tab 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:

For Visible/Editable you can define the following values:

  • Yes - field is always visible
  • No - field is always hidden
  • By Rule - additionally, by clicking the "Set rule..." button, it is necessary to set a condition that should be met for the field to become visible. For example, you can display the field only if a specific value is entered into another field.
  • Only For Groups - display only for specific user groups. You can select groups by clicking the "Set groups..." buttons.


  • Mandatory:
    • No - the field is not required to be filled.
    • Yes - the field is required to be filled. A record can not be saved if the field is empty.
    • Show Warning - the field is required to be filled. However, a record can be saved after confirming a warning message.
  • Unique:
    • No - any value can be entered into this field.
    • Yes, for a folder - only a value unique for the record's folder can be entered in this field.
    • Yes, for the DB - only a value unique for the database can be entered in this field. Please note, the software will scan the whole database to check the uniqueness and it can take a time.

If the System Field check box is selected for the field:

  • This field will never be used in simple search for all fields;
  • This field will be inaccessible for selecting from the "Folder->Table View->Columns..." menu (the list of columns that should be displayed in the table). At that, if this field is marked as visible in the Table Style Editor, a usual user will not be able to hide it in the table.
  • It will not be possible to manually sort records by this field.

We recommend you to hide and mark as system those fields, values of which are not intended for changing and viewing by the user (for example, results of intermediate calculations, history of work with the record and so on).

All topics in the "Fields" section: