Relationships/Join Fields

[Guest]

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

 

[Guest]

I would suggest reading the topics in Access help. They provide a nice
introduction to the topic.

Barry

 

[John Vinson]

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]

 

[Guest]

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.

Unless you click Enforce Referential Integrity! Don't forget about cascading
updates and deletes, too.