I've got an object Student and an object College. College has a collection of students and a student can be part of a College.
Mapping this in a relational database, I've got a table of students, a table of colleges. And an associative table CollegeStudents. The last only consists of a FK to the OID of a student and a FK to a College.
How can I get the students from a College (like oCollege.Students) and the College (if it has been assigned) from a student (like oStudent.College). The examples from your site only have direct associations between tables.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is a standard one-to-many association. Have a look at the sample code for order/orderline classes (in the source .zip download) to get an idea of how this is done.
If you still have questions after that, please feel free to ask.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I've got an object Student and an object College. College has a collection of students and a student can be part of a College.
Mapping this in a relational database, I've got a table of students, a table of colleges. And an associative table CollegeStudents. The last only consists of a FK to the OID of a student and a FK to a College.
How can I get the students from a College (like oCollege.Students) and the College (if it has been assigned) from a student (like oStudent.College). The examples from your site only have direct associations between tables.
Hi,
This is a standard one-to-many association. Have a look at the sample code for order/orderline classes (in the source .zip download) to get an idea of how this is done.
If you still have questions after that, please feel free to ask.