Delete relationship

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • francophone77
    #1

    Delete relationship

    I deleted a relationship in the relationship view, but when I create a
    query that includes those two tables, the relationship reappears. When
    I go back to the relationship view there is NO relationship but I can't
    seem to get rid of it for queries (without manually doing it for each
    query). Can anyone tell me whats going on??? TIA

    Tags: None
    • Anthony England
      #2
      Re: Delete relationship


      "francophon e77" <francophone77@ hotmail.com> wrote in message
      news:1131915543 .960870.75860@g 47g2000cwa.goog legroups.com...[color=blue]
      >I deleted a relationship in the relationship view, but when I create a
      > query that includes those two tables, the relationship reappears. When
      > I go back to the relationship view there is NO relationship but I can't
      > seem to get rid of it for queries (without manually doing it for each
      > query). Can anyone tell me whats going on??? TIA[/color]

      When viewing your relationships, right-click and choose Show All. I would
      expect the relationship to appear even if you have to move tables or search
      a bit to see it. In other words the rlationship *is* there it's just not
      currently being shown. What you deleted was an additional realtionship you
      set up.
      <that's the theory anyway>


        Comment

        • francophone77
          #3
          Re: Delete relationship

          I forgot to mention that I DID do a show all and in fact deleted all
          relationships just to make sure. But no matter what, that relationship
          always shows up when I bring both tables into one query.

            Comment

            • Anthony England
              #4
              Re: Delete relationship

              "francophon e77" <francophone77@ hotmail.com> wrote in message
              news:1131916159 .142591.184380@ z14g2000cwz.goo glegroups.com.. .[color=blue]
              >I forgot to mention that I DID do a show all and in fact deleted all
              > relationships just to make sure. But no matter what, that relationship
              > always shows up when I bring both tables into one query.[/color]


              If the fields share the same name
              and the same datatype
              and one of the fields is a primary key
              and Tools>Options>T ables/Queries>Enable Autojoin is selected
              Then the join will appear - so turn it off if you don't want this feature.

              If you suspect something is not as it should be try creating a new database
              and importing all the tables (but make sure under the options section that
              you choose not to import the relationships). Then you can re-create the
              relationships from scratch.


                Comment

                • Joe Black
                  #5
                  Re: Delete relationship


                  "francophon e77" <francophone77@ hotmail.com> wrote in message
                  news:1131915543 .960870.75860@g 47g2000cwa.goog legroups.com...[color=blue]
                  > I deleted a relationship in the relationship view, but when I create a
                  > query that includes those two tables, the relationship reappears. When
                  > I go back to the relationship view there is NO relationship but I can't
                  > seem to get rid of it for queries (without manually doing it for each
                  > query). Can anyone tell me whats going on??? TIA
                  >[/color]

                  Hi

                  Tools > Options, on Table/Queries tab, Query Design - tick box Enable Auto
                  Join is probably ticked.

                  - Joe


                    Comment

                    • Arno R
                      #6
                      Re: Delete relationship

                      "francophon e77" <francophone77@ hotmail.com> schreef in bericht news:1131916159 .142591.184380@ z14g2000cwz.goo glegroups.com.. .[color=blue]
                      >I forgot to mention that I DID do a show all and in fact deleted all
                      > relationships just to make sure. But no matter what, that relationship
                      > always shows up when I bring both tables into one query.[/color]

                      Perhaps Access is trying to be smart ...
                      -- Is this 'relationship' an innerjoin between two fields with the same name?
                      -- Both fields are also primary keys?

                      Arno R


                        Comment

                        • francophone77
                          #7
                          Re: Delete relationship

                          Thanks, AutoJoin WAS enabled.

                            Comment

                            • Trevor Best
                              #8
                              Re: Delete relationship

                              francophone77 wrote:[color=blue]
                              > Thanks, AutoJoin WAS enabled.
                              >[/color]

                              Now restore the backup that had all the relationships in before you sod
                              up the whole database.

                                Comment

                                Previous template Next
                                Working...