Complex Relationships (two fields from each table)
I am new to FileMaker Pro but I am familiar with Microsoft SQL. When I create a complex relationship (two fields from each table) I would expect the new Table Occurrence to show only the records from both tables where both fields match, like a filtered View in MS SQL. However, a get all records, is this what should happen? What would be the purpose of a complex relationship if this is true?