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?




      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??




      Juan Dent

        1 2 Previous Next