Link Related Tables

In this section you will learn how to link related tables for creating a customer portal

You can link different tables as long as there's a common field in both of them. In our case, we'll link by the Unit name field.

In Jet Admin you can link tables from different Bases

Display the Projects

Drag the Table component and change the mock data to your own. Select the data source you've connected and the page you want to display:

1. Drag and Drop the Table Component to the page

2. Choose the Resource and the Collection

Link the Tables

Each Unit has many Tasks and we want to see the list of Tasks for a given Unit. To create this flow, follow the steps:

1. Click on the Table

2. Click on the Filter icon

3. Choose Unit ID -> ID equals

4. Click on the Formula icon

5. Choose Units -> Selected Row -> ID

Now, let's customize our Portal:

Customize your Portal