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.