Hi Jason,
how can I joined these kind of relationship table ... I want the cloumn className to be part of my table studentSection. but when I joined the column className into the table studentSection. And put insert the rs_className into my page. there is no record appear when check into the browser.
students:studentID - Primary Key
studentName - text
etc...
class table: (parent)
classID - PRimary key
className - text
etc ...
and a section table:(child of class)
sectionID - Primary Key
sectionName - text
classSectionClassID - relates to class.classID
etc
studentSection(child of section table and student table) many to many relationship (but I want to joined the className column to my recordset to view the className of that section)
studentSectionID - Primary Key
studentSectionStudentID - relates to students.studentID
studentSectionSectionID - Relates to section.sectionID
Advanced Thanks...
