 |
Online Help System
|
 |
Back to Brilliant Database Web-Site |
Write to Support |
Help Index
Records
Creating Records
To create a database software record (database software records), use one of the following methods:
- Click the corresponding toolbar button;
- Select the Add > Add Record...
menu item;
- Make the database software 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 database software record(s). First select the database software records you want to clone, right-click the database software records and select the clone menu item:
To add a new database software record type, use
Form Editor.
Moving Records
You can move database software records in this program in the way similar to moving objects in Microsoft Windows: select the database software records you want to move and drag-and-drop them to
the required location. You can change the order of the database software records by sorting them
out.
Converting Records
Converting stands for transformation of a database software record into another type, or
data migration from one database software record field to another:
- Select the database software records to convert;
- In the Records menu select the Convert Selected Records... option;
- If there are several database software record types (forms) in the database, select the database software record type
to transform the selected database software records to (the initial database software record type can be
preserved);
- Specify the fields to convert the fields of the selected database software 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 database software records
with the same data:
- Select the database software records to be filled with the same data.
- For the current database software record, set the field value to the one to be applied to all selected database software records.
- In the Records menu select the Fill Selected
Records... option.
- Choose the field common for all database software records.
- Click OK.
Deleting Records
To send database software records into the Recycle Bin, select them in the database software records list and then
press the Del key on your keyboard or just move them to the bin. To permanently delete the database software 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 database software record access, application
keyboard user interface was thoroughly elaborated:
- After a new database software record is created (press the Ctrl+A key combination), the input focus is automatically set to the first database software 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 database software records. For example, you can insert photos or documents to a
database software record.
Adding file(s) to a Record
Method 1. Select files and move them onto the database software record header:
Method 2. Use the Record context menu that can be shown by right-clicking the database software record name in the database software records list or in the database software record window:
Opening, Saving and Deleting Attachments
If a database software record contains attachments, the database software 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 database software records you can make navigation through you database more simple and useful.
To add a link to a database software record, use the Record > Add Link menu item:
To open the links menu, click the icon in the left part of the database software record header:
Click the link to follow it or select the Delete Link(s)... menu item to delete
the links.
You can also connect database software records of different types using the relational
functionality.
| 
