I've never been good at relationships

[Patty]

After creating a relationship between two tables I am
told I will end up with a plus symbol (+) in front of
each row in a related table. I don't get anything.
Why do relationships have to be so difficult? Can
someone help me?
Patty

 

[Ken Snell [MVP]]

How are you setting the relationship? Are the tables in the same database?
Are they linked tables (the database is linking to them in another database
file)? More details, please....

 

[Van T. Dinh]

I am glad you finally explained Access Table relationships you have not been
good at ... <g>

If you defined the *One-to-Many* realtionship correctly (in the Relationship
window), you should only get the "Expand" (+) button in the DatasheetView of
the "Ones" (Parent) Table.

 

[John Vinson]

After creating a relationship between two tables I am
told I will end up with a plus symbol (+) in front of
each row in a related table. I don't get anything.
Why do relationships have to be so difficult? Can
someone help me?
Patty

The + icon is for "subtables" - which are an optional effect of a
relationship (in A2000 and later versions), but they are NOT the same
thing as relationships. They're not even particularly useful, and
using them causes your database to become noticably slower.

What version of Access are you using? As asked elsethread, what is the
structure and location of your tables? How are you establishing the
relationship?


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Patty]

-----Original Message-----


The + icon is for "subtables" - which are an optional effect of a
relationship (in A2000 and later versions), but they are NOT the same
thing as relationships. They're not even particularly useful, and
using them causes your database to become noticably slower.

What version of Access are you using? As asked elsethread, what is the
structure and location of your tables? How are you establishing the
relationship?


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
.
Thank you for the tip. It was simpler than I thought it

would be; I'm using an older version of Access. If I now
install 2000 or later will it make adjustments to the
database I've already built?

 

[John Vinson]

Thank you for the tip. It was simpler than I thought it
would be; I'm using an older version of Access. If I now
install 2000 or later will it make adjustments to the
database I've already built?

Generally, everything should transfer without problems (some VBA code
might need tweaking). I believe that tables converted from older
versions will automatically get subdatasheets turned on if you have
defined relationships in the Relationships window - I (and a few other
folks) have written VBA code to go through all the tables and turn the
durned things back OFF, because they cause marked slowdowns of
performance and provide zero benefit in a professional application.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps