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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy