Welcome to Forums Sign in | Join | Help | Forums
in Search


Forums » Technical Forums » Database Administrators/Technical » Linking the ADDRESS table with the constituent ID

Linking the ADDRESS table with the constituent ID

Last post 10-23-2008 9:46 AM by Rolf Gube. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 10-22-2008 5:01 PM

    • Rolf Gube
    • Not Ranked
    • Posts 8
    • Organization: Habitat for Humanity Canada

    Linking the ADDRESS table with the constituent ID

    Reply Contact

    I am trying to find out how the ID field that appears in the ADDRESS table is linked with the ConstituentID. I have viewed the RECORDS, CONSTIT_ADDRESS, CONSTITUENT, and CONSTITUENT_CODES tables and I cannot figure out how to link the ADDRESS table as none of the fields in those tables appear to match. Any help would be much appreciated.

     Thanks.
    Filed under:

  • 10-22-2008 5:11 PM In reply to

    • Drew Allen
    • Top 10 Contributor
    • Posts 514
    • Organization: Children's Hospital of Philadelphia
    • Products:  The Information Edge, The Raiser's Edge

    Re: Linking the ADDRESS table with the constituent ID

    Reply Contact

    Constit_Address.Constit_ID = Records.ID

    Constit_Address.Address_ID = Address.ID

    The address table is not directly linked to the constituent record, because they have a many-to-many relationship.  They are linked through the Constit_Address table.

    Drew

    J. Drew Allen
    The Children's Hospital of Philadelphia

  • 10-23-2008 9:46 AM In reply to

    • Rolf Gube
    • Not Ranked
    • Posts 8
    • Organization: Habitat for Humanity Canada

    Re: Linking the ADDRESS table with the constituent ID

    Reply Contact

    Thanks Drew! That was most helpful, I've figured out what I need to do now.
Page 1 of 1 (3 items)