ACC1x: Can't Create Two Relationships Between Same Tables

Last reviewed: May 28, 1997
Article ID: Q94189

The information in this article applies to:

Microsoft Access versions 1.0, 1.1

SYMPTOMS

If you create a second relationship between two tables that already have a relationship, Microsoft Access will automatically remove the first relationship between the two tables.

STATUS

This behavior is by design.

MORE INFORMATION

Steps To Reproduce Behavior

Create two tables that share a common field:

      Table: Table1
      ------------------------------
      Field Name: Test [Primary key]
      Date Type: Text

      Table: Table2
      ----------------
      Field Name: Test
      Date Type: Text

From the Edit Menu choose Relationships, and create a relationship between Table1 and Table2 on the Test field with the Enforce Referential Integrity check box selected. Choose Add.

Create another relationship between the two tables. Choose Add. Note that creating the second relationship removes the first.

Keywords : kbusage RltOthr
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.