Creating relationships

[Tony Williams]

Which is more efficient, creating relationships at the table level using
Tools->Relationships or creating the relationships between tables when I
create a query?
Thanks
Tony

 

[Tom van Stiphout]

On Tue, 23 Oct 2007 13:37:49 +0100, "Tony Williams" <[email protected]>
wrote:

The former is the only way to ENFORCE such relationships, which is
essential for a well-behaving database.

-Tom.

 

[JamesDeckert]

If you create the relationship for all tables, then you create a query the
tables in the query will be correctly linked. This reduces to possibility of
incorrect linking at the query level. I'm doubt there is any speed difference
between the two when running the query as the SQL created would be the same.

James

 

[Tony Williams]

Thanks guys
Tony

 

[Tom van Stiphout]

On Tue, 23 Oct 2007 05:50:01 -0700, JamesDeckert

Actually there would be a speed difference. If the relationships are
created in the Relationship window and enforced, Access will create
semi-hidden indexes behind the scenes.
If you just create a query and draw a line between two tables, I bet
you the same does not happen.
Indexed queries are faster than non-indexed ones.

-Tom.