Secondary Table

Note: A Secondary Table extension type is used to refer to:
  • Additional extension fields in an own extension table.
  • Additional existing application fields in an extension session.

Use a Secondary Table extension type to maintain more tables in one view. You can add 20 secondary tables to a session.

This table shows the available properties with an example:

Property Example value Explanation
Name txest100 Purchase Order extension table
Description Purchase Order Extension
Field List buyr, ‪badr List of extension update fields. Here, buyer and buyer address.
Mapping List otad<-->cadr The link from the main table to the extension table.

Here, the link from the buy-from address to the address code.
Initially hidden in overview Cleared By default not displayed in the overview session.
Initially hidden in detail Selected By default displayed in the detail session.

Once the extension is activated, the fields will be available in the session and you can move them to the desired location by clicking Personalization > Personalize Form. The fields are then ready for input, taking into account the defined DAL functionality.

The same functionality is available through the function sec.add.set.by.name() in before.program. The function can be used in an extension session in combination with adding the secondary table fields to the form. The function cannot be used to extend an existing application session.