AnsweredAssumed Answered

Join Question

Question asked by macguy918_1 on May 8, 2011
Latest reply on May 9, 2011 by raybaudi

Title

Join Question

Post

I have two tables.  The table on the left side of the relationship has more records than the table on the right side of the relationship.

I want to join these tables (they have unique keys that allow me to establish a relationship between the records) in such a way that I get all the records for the table of the left side of the relationship along with the data from the table on the right side of the relationship when the two key fields are equal.

I don't want only the records where there is a match between the key fields.  I want all the records in the left table.

I know how to set this up in other databases but I having trouble figuring out how to do this in Filemaker Pro.  Help would be appreciated.

Thanks

Outcomes