Welcome to SPN

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

Sign Up Now!

Linking Tables

Discussion in 'Information Technology' started by Jennifer Cali, Jul 28, 2006.

Tags:
  1. Jennifer Cali

    Jennifer Cali
    Expand Collapse
    Guest

    Ok, so I have a products table (tblProducts) and a contacts table
    (tblContacts). I have a primary key of an autonumber (atnContactID) on
    tblContacts that is linked to the field Contact ID (intContactID) on
    tblProducts. I then set intContactID as a combo box tied to atnContactID.

    So...when I went into tblProducts I can now select the ID from the dropdown.
    Trouble is when I'm in a form I can't see the name of the contact which is
    what I want...I could care less about the ID as it isn't used for anything.
    Any open suggestions on what I should do (or should re-do)?

    Thank you!!! You guys rock.
    --
    Thank you! - Jennifer
     
  2. Loading...


  3. Jennifer Cali

    Jennifer Cali
    Expand Collapse
    Guest

    Never mind - I figured it out!!!
    --
    Thank you! - Jennifer


    "Jennifer Cali" wrote:

    > Ok, so I have a products table (tblProducts) and a contacts table
    > (tblContacts). I have a primary key of an autonumber (atnContactID) on
    > tblContacts that is linked to the field Contact ID (intContactID) on
    > tblProducts. I then set intContactID as a combo box tied to atnContactID.
    >
    > So...when I went into tblProducts I can now select the ID from the dropdown.
    > Trouble is when I'm in a form I can't see the name of the contact which is
    > what I want...I could care less about the ID as it isn't used for anything.
    > Any open suggestions on what I should do (or should re-do)?
    >
    > Thank you!!! You guys rock.
    > --
    > Thank you! - Jennifer
     

Share This Page