Welcome to SPN

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

Sign Up Now!

Relationships change automatically (refer to screen captures)

Discussion in 'Information Technology' started by Cheese, Nov 2, 2005.

  1. Cheese

    Cheese
    Expand Collapse
    Guest

    Can somebody explain what is going on? I am using the "333 definitions" table
    five times because many fields in my main table require it, hence the reason
    why the other tables have naming extensions with _1, _2, _3, _4.

    In the relationships window, I configure everything as shown in the link
    below.
    http://img49.imageshack.us/img49/9094/1stsave1ks.gif

    I then save and close the Relationships window. Opening the Relationships
    window again, a split second after just closing it reveals that Access
    changed the relationships I had set-up. See the link below.
    http://img49.imageshack.us/img49/4383/2ndopen2sg.gif

    Why does this happen?
     
  2. Loading...

    Similar Threads Forum Date
    I'm open-minded about romantic relationships... how do I explain to family? Love & Marriage Aug 22, 2015
    Need advice...Sikhi in relationships Love & Marriage Nov 17, 2011
    Peer Pressure, Western Traits and Relationships Announcements Aug 23, 2010
    Peer pressure, western traits and relationships Sikh Youth Aug 23, 2010
    What is the Commitment in Relationships? Relationships Jan 24, 2010

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 1 Nov 2005 19:36:01 -0800, Cheese
    <Cheese@discussions.microsoft.com> wrote:


    >I then save and close the Relationships window. Opening the Relationships
    >window again, a split second after just closing it reveals that Access
    >changed the relationships I had set-up. See the link below.
    >http://img49.imageshack.us/img49/4383/2ndopen2sg.gif
    >
    >Why does this happen?


    I'm guessing that it only creates the extra instances if it is
    necessary to do so. Since 2ndopen2sg.gif unambiguously displays all of
    the relationships - needing only three instances of the table - it
    just uses the first three instances that it encounters.

    John W. Vinson[MVP]
     

Share This Page