Duplicate Tables Created in Relationship Window

[Guest]

Got an annoying problem: when I add tables to the relationship window, it
creates a duplicate. For example, it will add Tblequipment and
tblequipment_1. When I delete the duplicate and exit the window, the
duplicate comes back when I re-open the relationship window. How do I
eliminate this annoyance?

 

[Douglas J Steele]

Leave it be. Access is likely just creating a "shadow copy" of the table to
make it easier to be able to draw the lines.

 

[Guest]

No, it's not a shadow table as the tables are in separate places on the
screen, and it automatically draws the lines to both of the identical tables.

 

[Douglas J Steele]

The same relationship gets drawn twice? I've not heard of this before.

 

[John Vinson]

Got an annoying problem: when I add tables to the relationship window, it
creates a duplicate. For example, it will add Tblequipment and
tblequipment_1. When I delete the duplicate and exit the window, the
duplicate comes back when I re-open the relationship window. How do I
eliminate this annoyance?

It sounds like you may have the same relationship defined twice.
Deleting the duplicate table icon does NOT delete the relationship -
to do so, select the *join line* (not the table icon) and delete *it*.
You should then be able to delete the icon and have it stay gone.

John W. Vinson[MVP]

 

[Guest]

Yep, that was it. I've never had that happen before--the only thing I can
think of is that I created a couple of combo boxes in the tables relating to
the others, and of course it asks you if you want to create that relationship
when you create the combo boxes. I created the combo boxes before I created
the actual relationships. Anyway, who knows.

 

[dbahooker]

mdb is crap; Access Data Projects have diagrams that are MUCH superior
to the relationships window

 

[John Vinson]

Yep, that was it. I've never had that happen before--the only thing I can
think of is that I created a couple of combo boxes in the tables relating to
the others, and of course it asks you if you want to create that relationship
when you create the combo boxes. I created the combo boxes before I created
the actual relationships. Anyway, who knows.

That's one of the many, many flaws of the Lookup Field Wizard: it
creates a new relationship *even if one already exists*, and then
usually conceals it from view.

John W. Vinson[MVP]

 

[dbahooker]

yet another reason to never use MDB for a single record and a single
user.

i spit on people that use MDB.