Editing the union, except, and intersect custom tables

You can add and remove tables from an existing union, except, or intersect custom table. You can also update columns in these three types of custom tables based on column changes in their underlying reference tables.

Adding and removing tables

Use the following steps to add or remove tables from a union, except, or intersect table.

  1. In the data tree, the Relationships diagram, or on the Custom tables tab, locate the union, except, or intersect custom table that you want to modify.
  2. From the union, except, or intersect table context menu, select the Edit table option.
  3. In the table editor, click the Previous button to navigate to the Selected tables panel.
    Table editor
  4. In the Selected tables panel, select or deselect the tables to add or remove from the custom table. You might need to toggle from Selected tables to All tables if the table that you want to add is not shown.
    All tables view in the editor
  5. Click Next, then click Finish (in the preview panel), and save the data module.

Updating columns

You cannot add, remove, or modify columns directly in the union, except, or intersect custom table. However, you can modify the columns in its reference tables, and then update the columns in the custom table.

When the columns in the union, except, or intersect custom table differ from the columns in its reference tables, validation errors might be generated in the custom table.

Validation errors

To update the columns in the union, except, or intersect custom table, follow these steps:

  1. In the applicable reference tables, add, remove, or modify columns as required.
  2. In the data tree, the Relationships diagram, or on the Custom tables tab, for the union, except, or intersect table, click the Edit table option.

    In the table editor that is displayed, the table is shown with its updated (added, removed, or modified) columns. Verify if the updates are correct.

  3. Click Finish.

    The errors are cleared, and the columns in the custom table are updated.

    Note: If the reference tables do not adhere to the rules that are required to create a union, except, or intersect custom table, the Select tables panel is displayed so that the user can add or remove tables from the custom table. For more information, see Creating custom tables.