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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Many to Many

Author  Topic  despley Starting Member 3 Posts Posted - 2000-10-08 : 07:28:32 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?