Relationship restricting records.fmp12

Version 1

    This sample shows how FM relationships ARE NOT like SQL inner joins because all records in a table are shown even when there is not a corresponding record in a related table. Why is this? Is there a way to enforce an inner join like behavior?

     

     

    Regards,

    Juan Dent