How do I create multiple relationships in Access

L

Lost in Meds

I am trying to create a database full of many tables and I would love to
have the relationships for each table est so that I can pull up data from
each one if I desire to do so. But the relationship bar is so time consuming,
one click for each relationshp between each table for each form. And I want
to know if there is an easier way of est these relationships so that I dont
have to keep going click click click click for hours on end.
Any help would be soo great!!!
Oh and have a great weekend!!!!
:)
 
T

Timothy Lange

You mean setting the relationships each time you create a query? I believe you
can avoid that by creating the relationships by using the "Relationships" entry
under the Tools menu.

I also find that having the fields that establish the links to have the same
name in each table is helpful and that Access will automatically create links
based on the field names.

Tim Lange
West Lafayette, IN USA
(Go Boilers!)
 
L

Lost in Meds

Really?
Ok so how do I do that? do I just click on the relationship toolbar??
 
T

Timothy Lange

Yes, Tools, Relationships, then add your tables and set the relationships. Now
if you create a query, as you add tables the relationships should appear
automatically.

Tim Lange
West Lafayette, IN USA
(Go Boilers!)
 
L

Larry Linson

Really?
Ok so how do I do that? do I just
click on the relationship toolbar??
Click to expand...

On the menu, Tools | Relationships. Set the relationship in a similar way to
joining tables and setting the join properties in Query Builders. But, once
set, these relationships are set for good, and will be automatically used
when you add two (or more) related tables in a query.

In those instances where you may want to join related tables differently
than the defined relationship, you can delete the join made automatically by
the relationship and define a different one.

Larry Linson
Microsoft Access MVP
 
Top