If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
?Recursive relationships???
I seem to have related tables in such a way that the
relationship view automatically creates copies of two of my tables with _1, _2 etc at the end. Please can you tell me what I've done wrong? Thanks you. |
#2
|
|||
|
|||
You haven't necessarily done anything wrong.
Whenever ACCESS needs a second relationship between two tables, where the two relationships share one field from one table, ACCESS makes a "copy" of that table so that it can make the relationship. Similarly, this can happen when you create and save queries that have joins in them. So, unless your database is "not working" in some way that would be related to this issue, you're most likely just fine! -- Ken Snell MS ACCESS MVP "Lynette" wrote in message ... I seem to have related tables in such a way that the relationship view automatically creates copies of two of my tables with _1, _2 etc at the end. Please can you tell me what I've done wrong? Thanks you. |
#3
|
|||
|
|||
Thank you - that's reassuring as the database seems to
work. -----Original Message----- You haven't necessarily done anything wrong. Whenever ACCESS needs a second relationship between two tables, where the two relationships share one field from one table, ACCESS makes a "copy" of that table so that it can make the relationship. Similarly, this can happen when you create and save queries that have joins in them. So, unless your database is "not working" in some way that would be related to this issue, you're most likely just fine! -- Ken Snell MS ACCESS MVP "Lynette" wrote in message ... I seem to have related tables in such a way that the relationship view automatically creates copies of two of my tables with _1, _2 etc at the end. Please can you tell me what I've done wrong? Thanks you. . |
#4
|
|||
|
|||
You could also try hitting the 'Show All Relationships' button (or
Relationhips Menu, Show All); you may have some relationships with that table that are hidden. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |
Deleting Relationships... | Kojones | General Discussion | 3 | December 17th, 2004 11:46 PM |
Relationships getting redefined? | raylitalo | General Discussion | 3 | December 15th, 2004 08:31 PM |
Disappearing relationships | Dan | Database Design | 2 | August 6th, 2004 06:43 AM |
Not seeing all relationships in layout window | jettabug | General Discussion | 3 | June 18th, 2004 05:42 PM |