Jump to content

How to manage relations with an external data source (oracle connection).

Sara AlMousa

Recommended Posts

  • 2 weeks later...

Hi Sara,

To achieve filtering in related tables you need to follow the following steps:

a) Go to Data > Data Table Properties.

b).In Data Table Properties select the Relations tab and choose the Manage Relations button.

c).In the Manage Relations window, click the "New" button. The "New Relation" prompt will open. Select the column "Name" for both data table

2). Once the relationship is established between two tables, in the Filters panel at the corner of table name you will find the filter icon, 

3). Clicking the icon, the related data table with 3 options are displayed.

4). If you want the "Name" column in table T1 to control the rows in table T2, click the icon in Filter panel of table T2. Select the option "Filtering in T1" and choose "Include Filtered Rows Only".

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...