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

   Indicates the condition that stops the system from searching for
   additional records that satisfy the 1:N relation. dBsee automatically
   computers the break expression, and displays it on the definition frame.
   In this option, eventual modifications can be added to what is proposed by
   the system.

   The value of this parameter can consist of an expression on the fields,
   user functions or memory variables set in the Symbols environment or
   directly in this context.
    The Alt-1 keys rapidly insert the break expression on the rows.

   The definition of the options described above can take place in the
   environment accessed by the Options button. An edit is activated by
   pressing the Enter, Space Bar or by double clicking with the
   mouse. The Alt-1 keys can be used for building the expression
   interactively.

Example:

   A Way-bill Header file (WBHea) has a 1:N relation to the Way-bill Rows
   file (WBRow), so each way-bill header corresponds to many way-bill rows.
   The relation index set is WBRow1 and its indexkey expression is:

     WBRow->WBCod

   The primary positioning key

     WBHea->WBCod

   is the expression that is used to search for the first record in WBRow
   that corresponds to the current record of WBHea, i.e. having same the
   way-bill code stored in the way-bill header.

   The filter expression

     WBRow->WBCod==WBHea->WBCod

   indicates which records are to be considered. All the rows of the way-bill
   whose code corresponds to the header code will be selected.

   The Break expression

     WBRow->WBCod != WBHea->WBCod

   tells the system to end the search of the record in the WBRow file when a
   record whose code is different from the header code is found.

   This is the most efficient way to find the desired records and it is also
   a very flexible method; modifying the key expression, filter and break,
   you will be able to select any group of records.