Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Duplicate Tables Created in Relationship Window

Discussion in 'Information Technology' started by PPCO, Jul 28, 2006.

  1. PPCO

    PPCO
    Expand Collapse
    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?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Duplicate passports offered by GOI to Indians residing in Italy Breaking News Sep 19, 2009
    Sikh News Case of the duplicate signatures (San Jose Mercury News) Breaking News Apr 4, 2005
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    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.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "PPCO" <PPCO@discussions.microsoft.com> wrote in message
    news:2B224C08-F00D-408E-864B-51B638FB5C0E@microsoft.com...
    > 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?
     
  4. PPCO

    PPCO
    Expand Collapse
    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" wrote:

    > 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.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "PPCO" <PPCO@discussions.microsoft.com> wrote in message
    > news:2B224C08-F00D-408E-864B-51B638FB5C0E@microsoft.com...
    > > 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?

    >
    >
    >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

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

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "PPCO" <PPCO@discussions.microsoft.com> wrote in message
    news:514A2E96-B6AF-4F8D-BC81-0C13FD0DCA6A@microsoft.com...
    > 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" wrote:
    >
    > > 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.
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "PPCO" <PPCO@discussions.microsoft.com> wrote in message
    > > news:2B224C08-F00D-408E-864B-51B638FB5C0E@microsoft.com...
    > > > 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?

    > >
    > >
    > >
     
  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 8 Jun 2006 08:32:02 -0700, PPCO
    <PPCO@discussions.microsoft.com> wrote:

    >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]
     
  7. PPCO

    PPCO
    Expand Collapse
    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.

    "John Vinson" wrote:

    > On Thu, 8 Jun 2006 08:32:02 -0700, PPCO
    > <PPCO@discussions.microsoft.com> wrote:
    >
    > >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]
    >
     
  8. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

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



    PPCO wrote:
    > 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.
    >
    > "John Vinson" wrote:
    >
    > > On Thu, 8 Jun 2006 08:32:02 -0700, PPCO
    > > <PPCO@discussions.microsoft.com> wrote:
    > >
    > > >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]
    > >
     
  9. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 8 Jun 2006 12:12:01 -0700, PPCO
    <PPCO@discussions.microsoft.com> wrote:

    >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]
     
  10. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

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

    i spit on people that use MDB.




    John Vinson wrote:
    > On Thu, 8 Jun 2006 12:12:01 -0700, PPCO
    > <PPCO@discussions.microsoft.com> wrote:
    >
    > >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]
     

Share This Page