A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copies of Tables showing in Relationships Window



 
 
Thread Tools Display Modes
  #1  
Old July 27th, 2004, 07:12 PM
Alcide
external usenet poster
 
Posts: n/a
Default 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  
Old July 27th, 2004, 07:33 PM
Joan Wild
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.