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
|
|||
|
|||
Copies of Tables showing in Relationships Window
Hello All,
I am working on a problem in my data and using the Relationships Window to see what is going on. I've noticed that the Window shows copies of some tables that I have many-to-many relationships on. I Hide the tables, but was wondering what this is indicative of? |
#2
|
|||
|
|||
Copies of Tables showing in Relationships Window
Alcide wrote:
Hello All, I am working on a problem in my data and using the Relationships Window to see what is going on. I've noticed that the Window shows copies of some tables that I have many-to-many relationships on. I Hide the tables, but was wondering what this is indicative of? Usually this is a result of using the Lookup Wizard in your table. Even though you may have already created a relationship, Access will create a second one. You are safe to delete the second one - note you must click on the join line and hit delete, and then select the table and delete it. -- Joan Wild Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
e-mail window | R. Alan | Outlook Express | 5 | June 19th, 2004 08:15 PM |
Not seeing all relationships in layout window | jettabug | General Discussion | 3 | June 18th, 2004 05:42 PM |
RUNDLL window keeps showing up when I logon | Thom Dickerson | General Discussion | 2 | June 13th, 2004 07:25 AM |
Relationships between tables | Mel | New Users | 2 | June 11th, 2004 04:00 PM |
Need help with Tables Design and Relationships | Tom | Database Design | 24 | May 19th, 2004 06:51 PM |