I have a table A which has children in table B (a 1 to many relationship). This relationship selects from B those records that match the relationship criteria and sometimes the corresponding records in B are the empty set (non found).
I have a layout based on table A (the anchor), but I want to filter the layout so that only records in A that have corresponding records in B show.
And, I want this to be done via a relationship that limits records in A to the criteria I just stated.
How can I do this?