AnsweredAssumed Answered

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

Question asked by juandent on Sep 19, 2016
Latest reply on Sep 19, 2016 by BruceRobertson



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