AnsweredAssumed Answered

How can I restrict record via a relationship?

Question asked by juandent on Jan 12, 2016
Latest reply on Jan 12, 2016 by BruceRobertson

Hi,

 

 

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?

 

Thanks,

Juan

Outcomes