Can someone please give me insight into the join properties options when
defining relationships between tables? How do you know if the join fields are
equal to one another?
Thx
It's not very important whether you define the join type as Inner Join
(return only records where the values in the two tables match) or Left
or Right Outer Join (return all records in one table, and matching
records in the other). The setting does not affect what you can put in
the tables or how the tables work; it only sets the default join type
when you create a new Query and add both tables.
The join fields are equal to each other if the data in the table
contains equal values. If you have a join field containing 124 in one
table, and a linked field containing 124 in the other table, then
they'll be matched because 124 is equal to 124. I'm not sure I
understand the question!
John W. Vinson[MVP]
