AnsweredAssumed Answered

Complex Relationships (two fields from each table)

Question asked by LWayne_1 on Oct 24, 2011
Latest reply on Oct 24, 2011 by LWayne_1

Title

Complex Relationships (two fields from each table)

Post

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?

Outcomes