How do relations work?

[emacon]

HI,

I think I don't quite understand how relationships between tables work on the Designer.

I created relationships between the tables in my report, but by filtering the data in the Parent table, it still collects all the data from the Child table, and the relationship is also set as Active Relationship.

Shouldn't it also filter the Child table data accordingly? Am I doing something wrong?

[Lech Kulikowski]

Hello,

Relations are not applied for queries.
You can use variable to filter both tables
select * from parent where ID = {Variable}
select * from child where ParentID = {Variable}

Thank you.