many-to-many relationships
Jon Lapp
Hello,
Being a relative newbie to SQL Server 6.5 and Database administration, I
need to know the proper way of handling a many-to-many relationship in SQL
Server.
In know how to do it in Access using an intermediate table between the two
tables causing the many-to-many relationship. Is it done the same way in
SQL Server?
If so, how does the intermediate table get populated?
Or... should I try to normalize the tables better? I can see no way of
normalizing any farther than I have. I just can not eliminate the
many-to-many relationship.
TIA
Jon
Skip Sailors
<IMHO>
The many-to-many relationship transcends platform. If you have a good
logical model it will travel from Access to SQL Server.
If the many-to-many relationship accurately models the application
domain I'll bet you don't get rid of the link table. Sometimes link
tables happen. C'est le guerre!
To populate a link table, make sure that dependent tables contain the
information to which you are linking before you enter the link. You
might have to do all of this in a transaction.
</IMHO>
On 4 Mar 1998 13:56:08 GMT, "Jon Lapp" <j...@plantrol.com> wrote:
>Hello,
>
>Being a relative newbie to SQL Server 6.5 and Database administration, I
>need to know the proper way of handling a many-to-many relationship in SQL
>Server...