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 |
|
mattt
Posting Yak Master
194 Posts |
 Posted - 2002-01-25 : 06:45:46
|
| Hi,Forgive me for what is probably a stupidly simple question, but relationality always confuses me ...I have a 'main' table which contains a field, 'technologyID' which is linked to another table. This second table, 'technology' contains a 'technologyID' field and a 'technologydescription' field. I want the 'technologyID' field in main to be able to store more than one 'technologyID' link to the second table. I presume I can't just change it to a text field and input more than one number. Do I need another table inbetween to resolve the relationship or what? I hope this question makes sense :)Cheers,Matt |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-01-25 : 07:05:29
|
| Yes, in order to preserve your relationships you need a middle table that contains the unique key field from your main table and a row for each technology_id associated with the one record in the main table. You then link the new middle table to the technology table to get the description. |
 |
|
|
|
|
|
many to one relationships