Relationship restricting records.fmp12

File uploaded by juandent on Sep 19, 2016
Version 1Show Document
  • View in full screen mode

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

Outcomes