Filtering against cardinaliy, version May 2024

[Alina_A]

Hi, I am confused. I can filter against the cardinality of the relationship while I should not.

The situation is the following. I have 3 talbes (Table1 - T1 and so forth). T1- Personal_Data: employee_name, age, etc., T2- Employees: ID, employee_name, etc., T3- Children: employee_name, name_of_the_child (T3 is only for employees with children). Thus, T1 to T2 is one-to-one and T2 to T3 is one-to-many (one way cadinality from T2 to T3 - NOT bidirectional). And surprisingly I can make charts with data from T3 to T2 direction. In particular, I can make a chart with T3.employee_name and T1.age. And as far as I know, I should not be able to do so due to cardinality from T2 to T3 and not vice versa. I am using a version 2.129.1229.0 64-bit (May 2024). Is it working properly?

[MattAllington · Accepted solution]

Yes, a reverse implied filter is possible. Technically, the T1 table filters T2 which filters T3. Only matching records are retained. 

[Alina_A]

Thank You!