Click above to get retro games delivered to your door ever month!

   The relations that link various files together are fundamental elements
   that make an application function correctly. The relations, other than
   linking the files of the database, are indispensable for realising the
   functionalities of the data entry and report formats. A relation expresses
   the dependency between records of the files involved. The three types of
   relations handles by dBsee (1:N, N:1 and 1:1) express different modes for
   linking information stored in different files together.

   The integrity rules allow for specifying the mode of updating data in
   order to maintain the integrity of the database. Using the integrity
   rules, it is possible to avoid situations, in which data that should be
   linked becomes unlinked, like for instance an invoice with no associated
   customer.

   In the relations definition environment, after having defined the files
   and indexes, the parameters for the relations can be defined.

   The types of relations available are:

   N:1 (Lookup)            Many occurences in one file correspond to only one
                           entry in another file, on the basis of a common
                           key.

   1:1                     Each record of the first file will have one and
                           only one record of the second file correspond to
                           it.

   1:N                     A record of a file, through a common key, will
                           have many records of another file correspond to
                           it.

   Once all the relations of the database have been set, the actual
   definition of the application's operating sessions can take place.