Bestpractices

[Andy]

Are there any bestpractice when it comes to many-to-many relationships? I'm
building a database and at the moment it looks like I will have several
many-to-many relationships.

/A.

 

[Allen Browne]

The standard solution is to add a junction table that breaks the
many-to-many into a pair of one-to-many relations.

Basic example:
http://allenbrowne.com/casu-06.html