General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
A many to many relationship
I'm trying to establish a MtM relationship between 2 tables. One is a students table, each student has a unique Id#, and the other is a classes table. Each class has a unique Id# also. I'm using a 3rd table as a link between those two students-classes tables, but somehow I'm not getting the expected results. Cant' build a view with these 3 tables. I got error message saying one same table can't be the child for two parent tables. Any general guidelines on how to succesfuly accomplish this?
Thanks in advance for your time.
Ulises.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only