1 2 Previous Next 20 Replies Latest reply on Sep 19, 2016 6:56 PM by BruceRobertson

    Shouldn't relationships "filter" what records are displayed?

    juandent

           Hi,

       

      I have a new table A with one field idf_b (to work as a foreign key to B) and another table B with one field id_b (its primary key auto generated serially).

       

      I created a layout that includes a table occurrence of A and one of B and I expected  that the only records to be shown were those for which the relationship was true (i.e.  A.idf_b == B.id_b).

       

       

      Instead it is showing me ALL records in B regardless of the existence of a corresponding foreign key in a A! This goes against my understanding of relationships!!

       

      Is there a setting? How can I accomplish this??

       

      Thanks,

       

      Juan Dent

        1 2 Previous Next