Setting Up Related Tables

What are Related Tables

Related tables refer to tables with a relationship, such as 'Order Table' and 'Order Details Table'. For example, the 'Order Table' holds common information such as order number, client, order acceptor, and order date for one order, while the 'Order Details Table' holds multiple occurrence details such as product code, quantity, etc. In this case, multiple 'Order Details Table' data are associated with one 'Order Table' data, therefore in CELF Web App creation, the 'Order Table' is referred to as the original table and the 'Order Details Table' as the related table.

../../../_images/img_01.en259.png

What You Can Do with Related Table Settings

In CELF Web App creation, you can associate a related table with the selected table. By associating a related table, for example, when displaying one record of data from the 'Order Table', you can list the data from the related 'Order Details Table', and you can associate new data from the 'Order Details Table'.

Associating the Original Table with the Related Table

Click the 'Add' button in the related table settings to display the related table settings dialog. Multiple related tables can be added.

../../../_images/img_02.en245.png

  1. Select the table that will be the related table of the original table.

  2. Add the column of the related table that corresponds to the column of the original table. Multiple columns can be associated.

    Tip

    • Columns in the related table can only be selected if they have the same data type as the columns in the original table.
    • Because the values of columns in related tables are automatically updated by the association with the original table, the ID, LAST_UPDATER, and LAST_MODIFIED, which are defined and cannot be changed in all tables of the CELF database, cannot be specified as columns in related tables.

  3. Click the 'Next' button.

Customizing the Operation of the Related Table

Customizing the operation of the related table is the same as Customizing the operation of the app, except for the following points.

  • In 'Set the visibility and editability of columns', search conditions are not subject to configuration.

    Tip

    The search condition will not be used because the data of the related table is narrowed down by the column correspondence with the original table.