Duplicate Tables Created in Relationship Window

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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.
 
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?
Click to expand...

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]
 
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.
 
mdb is crap; Access Data Projects have diagrams that are MUCH superior
to the relationships window
 
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.
Click to expand...

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]
 
yet another reason to never use MDB for a single record and a single
user.

i spit on people that use MDB.
 
Back
Top