Trouble Creating Foreign Key

  • I think this one is a misunderstanding on my part, hoping someone can set me straight.

    I've got 3 tables: 'user', 'contact', and a table to associate the two.

    The idea is that a 'user' is used to log into a website, but there can be multiple

    'contacts' associated with the user.

    So I've got simple int identities in 'user' and 'contact' as primary keys.

    In the user_to_contact table I just have two int values that are supposed to be two

    foreign keys.

    When I try to create the foreign keys, I get an error saying that I cannot create the foreign key from user_to_contact as it conflicts with a foreign key constraint.

    Totally lost now.

    If I need to explain myself more, please let me know, could really use some help on this one.

    Cheers,

    McWare

    -- McWare

  • Nevermind, I'm an idiot.....

    Turns out there was bad data in one of the tables,

    Sorry for the trouble.

    -- McWare

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply