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




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?