Definition of Terms Used Throughout This Help Document

Remember Context Sensitive Menus

There are many places where you can access the list of available actions by pointing your mouse on an item and right clicking. These items are:


A CATALOG ise the major structural item of a database where you store certain type of information.
This may be anything you can imagine: Inventory, Address Book, Books, Companies, Document Library, Flowers... etc. are all different catalogs.
You may create any number of catalogs in your database.
When viewed in tabular (spreadsheet style) form, a catalog corresponds to a whole TABLE with rows and columns.


A FIELD ise the second level structural item of a database. Every catalog contains several fields to store information. For example, an "Address Book" catalog may contain fields like name, phone number, birthdate etc. to store information for each person.
When viewed in tabular (spreadsheet style) form; each field corresponds to a COLUMN and field name to column header in a table.


A RECORD is a set of information you have typed into the fields of a catalog. So it is NOT a part of the structural information of a database. You may create, update or delete records as needed. You may have any number of records in a catalog.
When viewed in tabular (spreadsheet style) form; each record corresponds to a ROW in a table.


When you are viewing the records of a catalog in tabular style, you may need some customizations about how the records are displayed. Views determine which fields are displayed, how records are sorted and filtered out.
Every catalog may have any number of views (or none) under it. Views are displayed under each catalog folder they belong in the catalog tree.
See Understanding Views for details.


A filter is a group of rules which is applied to a certain view when displaying a record list. Every view can have its own attached filter. Filters are saved in your database with the view it belongs to.
Example: If you sometimes need to quickly access the list of contacts who are customers and ones who are friends at other times, it is best to have two views with appropriate filters.

Record Details Window (or shortly Form)

A form simply consists of boxes where you type in information to create or update a single record. A form window (or record details window) is opened whenever you click the "new record" button from toolbar or doubleclick a row of record. You may arrange the locations of each field according to your preference using Form Designer. Every catalog has a single associated form with it.

Form Menu

Form menus are the menu buttons displayed on the left side of a form. If a record has some relationship with a group of other records from another catalog, you may access that list of related records by clicking a menu button. For example, if there is a relationship between companies and people catalogs, you may easily display the list of workers while you are viewing a company record.
See Creating Relationship and Creating Form Menus for more info.


A relationship is defined between two catalogs. It helps to easily access the related information stored in the second catalog while you are viewing a record details of the first catalog. Creating relationships (whenever possible) greatly enhances the performance and ease of information management in your working environment.
See Creating Relationships for more info.

Next Topic: Record List Panel

Online Help Home Page   ::   SpeedBase Software Home Page