Re: Relationships with same primary key but multiple different foreign keys

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allen Myers (rocketjumped_at_hotmail.com)
Date: 04/01/04

  • Next message: Paul Clement: "Re: problem using Access 2000 database with VB 6.0 app" 
    Date: Thu, 1 Apr 2004 10:56:46 -0700

    "Joe "Nuke Me Xemu" Foster" <joe@bftsi0.UUCP> wrote in message
    news:%23%23bVBVwCEHA.3748@TK2MSFTNGP11.phx.gbl...
    > You'll need to define two separate relationships.

    Well, I'm not sure how to do that in Access. I've dragged and dropped the
    two fields from their foreign table onto the primary table key field, but
    when I drop the second, Access tells me a relationship already exists and
    asks if I want to edit that instead. When I say yes, it allows me to define
    the same primary key and a different foreign key. So how do you accomplish
    such a separation?

    See my post I just posted a few minutes ago also, I may simply be explaining
    my situation wrong. :(

  • Next message: Paul Clement: "Re: problem using Access 2000 database with VB 6.0 app"