Create Master Data Management
A Master Data Management is established for an
Index File. For this, the mask must be empty.
With the Master Data Management the programmer
can implement the basic functions of a database management without having to do
any coding work him/herself.

Master Data Management for file: Specifies the name of the Index File for which the Master Data
Management shall be established. An Index File can be selected with F2 or F7.
Create Index File Fields from field number: If you enter 0 or 1, all fields of the Index File will be entered on
the mask (provided that there is enough space available). If you enter a number
> 1, only the fields from the specified number on and the fields of the
primary key of the Index File will be considered. The created mask field is
labelled with the field name of the Index File field. You can move, delete or
change the mask fields and labels as you like.
Two Stage File Management: Often a two stage Master Data Management is established (e.g. invoice
head + invoice positions).
Create select button: In addition to the buttons ’save’
and ’delete’ another button for selecting data records is created. On a further
mask it can be specified which fields shall be shown in the selection.
Select starts at beginning of Index File: With pushing the Select button the function SELECT for displaying the data records is executed. If this checkbox is set,
the instruction INITIALIZE <INDEX
FILE> will be executed before SELECT is called. In this way the display
always begins with the first data record of the Index File. If this checkbox is
not set, the first displayed data record will be the current data record of the
Index File.
Clear fields when a new data record is created: When a data record is newly recorded, all mask fields are deleted
automatically.
Clear fields when a data record has been
deleted: After a data record has been deleted
successfully all mask fields are deleted.
Confirmation before data record is deleted: The data record will only be deleted after the user has confirmed that
he/she really wants to delete the record.
Message when data record has been deleted: After the data record has been deleted a message will confirm that the
record has been deleted.
If the checkbox Two Stage File Management
is set, a new mask will appear, on which the subordinate file must be
specified.

Secondary Index File: Here the name of the subordinate Index File must be specified. With F2
or F7 an Index File can be selected. The condition for a two-stage data
management is that the primary key of the subordinate Index File has the same
structure as the primary key of the master data file. In addition to that, the
primary key of the subordinate file must have an serial number (=numeric field
without post decimal positions) as last field.
Example: Invoice
head and invoice positions: The primary key of the Index File invoice
head is the invoice number. The primary key of the subordinate Index File invoice
position consists of invoice head + serial number. Every position of the
invoice is saved as data record in the Index File invoice positions.
Show items permanently: If this checkbox is set, the
fields for displaying the data records from the subordinate file will
permanently be displayed on the mask, otherwise a window for editing the data
records of the subordinate file will appear after the last field of the master
data file.
Window with Title Bar: The
subordinate file can be edited over the function SELECTA. A window
is opened, in which the data record of the subordinate file can be edited. If
the checkbox Window with Title Bar is set, a window with title bar will be created; in the opposite
case a window without title bar will appear.
Window Title: Specifies
the heading displayed in the Window with Title Bar.
Alignment:
Specifies whether the fields of the subordinate file are displayed in the
center of the mask or left-justified.
Number of Items: Specifies
the maximum of data records of the subordinate file that shall be edited.
On another mask you can select the fields of
the subordinate file that shall be displayed or edited. All fields except of
the fields of the primary key can be selected, even the serial number of the
subordinate file. The serial number is displayed in the program, but it cannot
be changed.

In the column Show and Change the fields to be edited are displayed. By
double-clicking, the RETURN key or the right mouse button a field from the
column Fields of secondary Index File can be moved into the
column Show and Change. Analogously a field from the column Show
and Change can be removed again. A field heading can be changed by
double-clicking on it or pushing the RETURN key.
Button 'All Fields': All fields from Fields of secondary Index File are entered
in Show and Change.
Button 'OK': The
settings are adopted and the mask is closed.
Button 'Cancel': The mask is closed and program execution continues at the mask Create
Master Data Management
If the checkbox Create Select Button
is set, another mask will appear, where you can specify which fields shall be
displayed in the selection.

In the column Show in Selection
the fields displayed in the selection are shown. By double clicking, the RETURN
key or the right mouse button a field from the column Fields of Index
File can be moved into the column Show in Selection.
Analogously a field from the column Show in Selection can be removed
again. A field heading can be changed by double-clicking on it or pushing the
RETURN key.
Button 'All Fields': All fields from Fields of Index File are entered in Show
in Selection.
Button 'OK': The
settings are adopted and the mask is closed.
Button 'Cancel': The mask is closed and program execution continues at the mask Create
Master Data Management.