for collection ‘Misc’
windows can be used to view records in a grid fashion. Using a table you can
choose the fields you want to see, set the preferred column size, you can
filter, browse, insert, delete and edit your records.
is related to a particular collection, except the “all collections” table,
where you can see all records of all collections. In the “all collections”
table you have the “collection” field, which is not available in the other
“all collections” table is also used to display the results of a global
open a table using the appropriate collection icon in the toolbar or the
appropriate command in the main context menu. In addition, you can open a table
by clicking the “table view of active form” icon when a non- table form is
records by column
clicking on a column header, you will cause the records to be ordered by that
column, in ascending or descending order (each time you click the direction is
inverted). An asterisk placed after the column name will remind you which is the
column currently used for ordering.
of column size and visibility
dragging and dropping the column separator, you can adjust the column sizes or
even make a column invisible or visible again. The size of the table window
itself can be adjusted by dragging and dropping the window’s borders.
preferred setting of a table in terms of column sizes and visibility and form
size is saved when you close the window and restored the next time you open it
again. Preferences are saved on a collection basis, meaning that for every
collection you can set different preferences.
opening of a table for the ‘contacts’ or ’dictionary’ collections, a
search window may appear, prompting you to insert a search pattern. If you are
not interested in finding or filtering particular records, just press ‘ok’
or ‘cancel’ without entering any pattern.
visible column (except ‘expiration date’ and ‘reminder date’ columns) a
filter box is available. You can enter characters in these boxes in order to
have a filtered view of the collection. For the ‘category’ column (and the
‘collection’ column in the ‘all collections’ table) a lookup list is
available from where you can choose among all the different values present in
that field for all records. Every time a filter is changed, the table is
regenerated according to the new filter.
button ‘clear’ will clear all filters at once. The ‘and’ and ‘or’
options will determine whether filters should be applied as an ‘and’ or
are automatically set after a search or global search operation.
records using edit boxes
visible field an edit box is available. As the ‘content’ field may contain
up to 30031 characters, an additional, larger edit window is available for this
field and can be opened by pressing the ‘zoom’ button.
‘category’ (and field ‘collection’ in the ‘all collections’ table)
can be filled by means of the available lookup lists, which allow you to select
among the different values already present in the database for the applicable
‘expiration date’ and ‘reminder date’ can be checked or unchecked for
any given record. When checked, the record becomes visible in the calendar
window. When unchecked, these fields are considered null and the record is not
taken in consideration in the calendar window.
records directly on grid rows
edit record fields directly on the grid rows. In order to save the change, you
can just move to another row or press the ‘save’ button.
of the ‘id’ field with collections ‘books’ and ‘media’
inserting a new record from a collection table the ‘id’ field will be
automatically filled with the highest number found in that field for that
collection, increased by one. This may be useful to assign unique serial numbers
to your records. Anyway, you can modify the content of this field at any time.
file and directory links
‘file’ and ‘dir’ buttons can be used to create file and directory links
in the ‘content’ field of a record. This can be done for any collection, not
just the ‘file links’ collection.
edit/insert operations and closing the window
edit or insert operation is open, you can cancel it by pressing the “cancel”
button or the “ESC” key. If you press the “cancel” button or the
“ESC” key while no insert or edit operation is open, this will cause the
table window to close.
the record sequence by drag and drop
alter the record sequence by dragging and dropping rows in the position you
prefer. It is required that you keep the ‘shift’ key pressed while you do
this operation. If the new position implies a change of category, the program
asks you to confirm the change of category. If you do not confirm it, the move
operation will be cancelled.
See Table Context Menu
for all commands applicable to this window.