Trouble Creating Foreign Key

• Todd McDonald

  SSC Enthusiast

  Points: 160

  More actions

  February 10, 2006 at 7:57 am

  #168233

  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

• Todd McDonald

  SSC Enthusiast

  Points: 160

  More actions

  February 10, 2006 at 8:31 am

  #620161

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

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

  Sorry for the trouble.

  -- McWare