1 Reply Latest reply on Jan 12, 2016 11:19 AM by BruceRobertson

    How can I restrict record via a relationship?

    juandent

      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