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.