:

    Data Grid

      2 minute read  

    With the Data Grid multiple entries can be assigned to one element. For example, to one process multiple system can be assigned. The mapping is stored in an additional table, which contains the two primary keys.

    To create a Data Grid following fields are required:

    Specific Properties of a Data Grid Control
    MappingForeignKeyFieldHere, you can specify the foreign key field of the table to be used to define the relation to the table to be linked.
    MappingReferenceFieldHere, you can specify the field in the related table where the selected data from the reference table will be saved.
    MappingTableHere, you can specify the name of the table that relates both fields to be linked.
    ReferenceTableHere, you can specify the Name of the table to be displayed in the data grid. This table contains the list of the available items.
    IconsFor the data grid, an icon can be selected to be displayed in the data entry screen. If desired custom icons can be defined for different types. For example, for each system type (workstation, server, etc.) the appropriate icon.
    UseParentObjectAsFilterIDThis setting defines whether the variable {FilterID} is replaced with the primary key of the parent object instead of the current object.
    SortedThis option sorts the entries alphabetically according to the first column. If this option is not active, views will use the sorting specified in the statement, and tables will display the data in the order in which it was inserted into the table.