Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-24 : 17:18:44
|
Dave Espley writes "Please help,
I have a database that contains index terms for news stories. Each of these terms can have more than one parent, i.e
Index_ID, Parent_ID
1 1
2 2
3 3
4 1
4 3
5 2
6 2
6 3
The database has three tables (well for the sake of this it does ; )
STORY
Story_ID, Story
J_STORY
Story_ID, Index_ID
INDEX
Index_ID, Parent_ID, Index_Term
As can be seen, the J_STORY table acts as a junction between the STORY and the INDEX tables. The INDEX table has a paired primary key on Index_ID and Parent_ID allowing there to be index terms with different parent.
My problem is how do I set up the relationship between J_STORY and INDEX!
Also is this the best way around this problem?
I am using SQL server 7
on
Windows 2000 sp1
" |
|
|
|
|
|
Many to many relationships