0

I have an sql table that stores English words and second table that stores meanings of those words in related maner.
Here are some informations about table structures:

Table1 name: Words
WordID int IDENTITY(1,1) NOT NULL, //This is primaryKey
Word varchar(50) NOT NULL,

Table2 name: Meanings
MeaningID int IDENTITY(1,1) NOT NULL, //This is primaryKey
WordID1 int) NOT NULL, //This is foreinKey
WordID2 int) NOT NULL, //This is foreinKey

All I want is that, use the WordID from the table “Words” as the word I want to give a mening and store it in WordID1 column of the table “Meanings”. Also use the WordID from the table “Words” that corresponds to the meaning of the word I select and store it in WordID2 column of the table “Meanings” as meaning of that word.
When I try to insert the record, using sql management object, I receive a forein key conflict constranct.
So can anyone help me overcame this?
Please help!

4
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by codemasters
0

I agree with utrivedi. My guess is you've used the graphic environment to join the 2 tables and see only the 2 word fields and it didn't work. What you need to do is insert both words in the Words table and then insert their "relationship" in the Meanings.

0

I feel that a foriegn key must be a primary key to some other table.WordID is a primary key to words table ,so this column can be used as a foriegn key to meanings table where as wordid1 and wordid2 are not primary keys, so these columns can not be used as foriegn keys.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.