|
One record form contains field names and controls for viewing and editing them. If a field
is marked as bold, it is a part of the table primary key. If some field is a foreign key,
a combo box where you can select a value for it is displayed (this list is generated based
on the information from the table this field is linked to).
After you make the necessary changes in the form, you can update (Ctrl+U hot key)
the record in the table or save it as a new record (Ctrl+I hot key).
Besides, the program allows you to delete the current record. For
that there are corresponding buttons on the toolbar and items in the Record menu. To clear
the form (it is usually used when you create a new record), you can use the "Clear form" command.
Note that if a field in the table is linked to another table by a foreign key, instead of
an edit box the program will offer you a combo box with key values from the linked table as a
means of editing such a field. The program provides you with a more visible way of selecting
due to the fact that it can show not only the key values, but also the values of the selected
field (called "key description field") that, you think, characterize the key value in the best
possible way.
The program supports export and import operations for large objects (BLOBs). The buttons for
performing these operations are located next to the field name on the form. Besides, the program
allows you to view objects of this type using external tools. If an object is in a well-known
format (such as Microsoft Word Document or PDF) and the tool required for viewing it (MS Word
or Acrobat Reader) is installed on the user's system, the program will start it automatically.
If the format of an object is not recognized, the user himself can choose the necessary program.
To find out the type of a table field, just move the mouse pointer to the corresponding
edit box and you will see the necessary information in the tooltip.
The title of the form for editing a record shows the name of the current table, the number of the
active record and the total number of records in the table.
Also you can use an external editor by pressing F4 key. By default,
external editor is Windows NOTEPAD.
Our product allows you to drag-n-drop text data from external sources (like Microsoft Word) to the form field.
|
