Using Filters with Referenced Tables

This tutorial demonstrates how to use the filter function for Referenced Tables.

  1. Configure the first database table. This table contains a column that is used for filtering, in this case the SupplierID column.

    Image showing the Supplier ID

  2. Configure the second database table. Add the corresponding value of the SupplierID column to each row.

    Image showing the corresponding column

  3. Define a referenced table for each database table in Therefore™. Include the column that is used for filtering as the Unique identifier. Fields from these tables can now be added as index fields to a Therefore™ category.

    Image showing the referenced table configuration Image showing the second referenced table configuration

  4. Create a category including an index field for each unique identifier.

    Image showing the category containing the unique identifiers

    Info Icon

    In this example, the filter fields are hidden in the UI. Instead, two text fields (Supplier Name and Payment Conditions) are configured so that the user will be able to intuitively interact with them.

  5. Double-click on the index field that should contain filtered values to open the Field Properties dialog. Go to the Filter tab to configure the filter relation.

    Image showing the Filter tab of the Field Properties dialog

  6. Now, the second table is filtered to only include the relevant information when a row from the first table is selected in the UI.

    Image showing the user experience when entering a supplier Image showing the filtered payment conditions for the supplier