The All-in-One Database Software Solution

Online Help System

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

Records

Creating Records

To create a record (records), use one of the following methods:

Click the corresponding toolbar button;
Select the Add > Add Record... menu item;
Make the records list active and then press the Ins key on your keyboard;
Create a button on a form with the Add Record action.
Clone existing record(s). First select the records you want to clone, right-click the records and select the clone menu item:

To add a new record type, use Form Editor.

Moving Records

You can move records in this program in the way similar to moving objects in Microsoft Windows: select the records you want to move and drag-and-drop them to the required location. You can change the order of the records by sorting them out.

Converting Records

Converting stands for transformation of a record into another type, or data migration from one record field to another:

Select the records to convert;
In the Records menu select the Convert Selected Records... option;
If there are several record types (forms) in the database, select the record type to transform the selected records to (the initial record type can be preserved);
Specify the fields to convert the fields of the selected records to:
Click OK.

Note. The data won't be converted if association between different data types cannot be set (e.g., between an image and a text);

Filling Records

By Filling Records we mean filling the same field of different records with the same data:

Select the records to be filled with the same data.
For the current record, set the field value to the one to be applied to all selected records.
In the Records menu select the Fill Selected Records... option.
Choose the field common for all records.
Click OK.

Deleting Records

To send records into the Recycle Bin, select them in the records list and then press the Del key on your keyboard or just move them to the bin. To permanently delete the records, clean out the Recycle Bin. To do that, click the Recycle Bin icon with the right mouse button and select Empty Recycle Bin from the context menu.

Editing Records

To accelerate the database record access, application keyboard user interface was thoroughly elaborated:

After a new record is created (press the Ctrl+A key combination), the input focus is automatically set to the first record edit form field;
Use the Tab key to navigate to the next field. In Form Editor you can customize the tab order;
Use the Enter key to access the auxiliary input functionality. For instance, when pressed in the date input field, it opens the calendar, and when pressed in the list field, adds a new value.

Working with Combo Field

If enabled, click the [*] button located next to this field to add or remove values in the dropdown list:

Working with Date Field

To change the date, double-click the date field:

The yellow color shows the current date, while the red color stands for the selected date.

Working with Images

To get access to the image menu, right-click an image:

Import image from a file - used to add an image to the database from a graphical file (BMP, JPG or GIF);
Import image from the clipboard - used to add an image to the database from the standard clipboard;
Acquire Image - used to add an image to the database from an external source such as scanner or camera.
Save Image As - used to save the current image as file on a hard drive or on a disk;
Copy image to the clipboard - used to copy the current image to clipboard. Afterwards you can easily insert it in any program;
Open Image - used to open an image in a separate window;
Delete Image - used to delete an image from the database.
Convert to jpeg - used to convert an image into the small-size JPEG format.

Working with the Many-to-Many Relational Fields

Click to learn more about many-to-many relational fields...

Working with the Text Button Field

Click to learn more about text button fields...

Attachments

Using this program you can attach files to records. For example, you can insert photos or documents to a record.

Adding file(s) to a Record

Method 1. Select files and move them onto the record header:

Method 2. Use the Record context menu that can be shown by right-clicking the record name in the records list or in the record window:

Opening, Saving and Deleting Attachments

If a record contains attachments, the record header will change its appearance. To open the attached file, select it from the dropdown list available by pressing the Attachments button:

Select the Save/Open/Delete Attachments menu item to open the attachments window:

Delete selected: used to delete the selected attachments;
Open selected: used to open the selected attachments using default associated applications;
Save selected: used to save the selected attachment(s) on to a disk as files.

Links to Records

Using links between records you can make navigation through you database more simple and useful.

To add a link to a record, use the Record > Add Link menu item:

To open the links menu, click the icon in the left part of the record header:

Click the link to follow it or select the Delete Link(s)... menu item to delete the links.

You can also connect records of different types using the relational functionality.