February 10, 2006 at 7:57 am
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
February 10, 2006 at 8:31 am
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