relationships4

[a]

What is benefit of relationship window to me in access 2007??

Because I will use my Queries to join my tables

I hope you understand me

 

[boblarson]

Setting the relationships helps you maintain data integrity. Also, if you
set up the relationships then when you add tables to your queries, the joins
are made automatically for you, so you won't need to make the joins each time
you start a new query.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Arvin Meyer [MVP]]

Relational databases are based mathematically on Relational Set Theory in
Calculus. Another way of saying relationship is DRI, that is Declarative
Relational Integrity. It ensures that there is data integrity between tables
(i.e. you cannot add records to the many side of a relationship unless there
is a matching Primary Key on the one side) That cannot be enforced by query
joins.