Relationships don't show....

[JillM]

Possibly a very basic question, but I have an Access database created in Access 2003, and when I open it in Access 2010 (just acquired!) I cannot see the relationships between the tables.

Any help much appreciated!

 

[rammudali]

hi

try to create once again. but dont forgot to do the same in a copy of orginal

 

[RainLover]

rammudali

Is this behaviour normal.

 

[rammudali]

hi
I think so. if this is woking, you use the new one as master and other as backup

 

[RainLover]

Thanks and apologies to the OP for taking over.

Does this mean the relationships are broken or simply not showing.

 

[rammudali]

hi,

if we opening mdb in access2007 or 2010 or importing all tables, queries, reports, forms etc to 2007 or 2010 relationship is visible, from my experience. without seeing the refered the db, it is not right to comment any more and i am not an expert to that extent

 

[RainLover]

hi,

if we opening mdb in access2007 or 2010 or importing all tables, queries, reports, forms etc to 2007 or 2010 relationship is visible, from my experience. without seeing the refered the db, it is not right to comment any more and i am not an expert to that extent

You did help.

I will do some testing next time I am at a 2010 Machine.

 

[JillM]

Thanks for replies - I didn't create this database, am looking at it for a friend. I now discover that it would seem that the relationships haven't been created at the table level, only at the query level. I'm a bit surprised by this as I was always taught that the relationships should be created at the table level as basic database structure.

Interested in any comments.

Thanks again.

 

[RainLover]

Jill

It appears that you have No Relationships.

You are correct that Relationships are created between Tables. This is where some basic rules are set like "Enforce Intregity".

You may be interested in knowing that most other Database Engines do not have this facility.

In the query you can set up joins. This is where TableOne shows matching records to TableTwo or All records from TableOne and only those that match from TableTwo etc.

You do not have to have Relationships but it is a very good practice. Sometimes you could have a Table with No Relationship to any Table like a List of Dates.

 

[JillM]

I always thought that if the relationships were created in the tables, then those relationships would automatically exist in the queries and thus make the queries more straightforward?

 

[RainLover]

I always thought that if the relationships were created in the tables, then those relationships would automatically exist in the queries and thus make the queries more straightforward?

This is True but if you right click on the Join (In the Query design) you will see that it is always option one. You can change it if you wish.

BTW

I always create the Relationships. And in some large projects I will print a PDF to fit A2. I would put that on a stick and go to a print shop to have it printed. I would then pin that to the wall in my office to use as a Road Map. Very Useful.