Object Oriented VB6 programming and DAO
I am an intern at Indiana State University working on a program for their Career Center. I have developed an Access database consisting of 2 tables which have a one to many realtionship between them. Each of these tables are accessed through a class object that defines strings for the database fields. I am using DAO 3.60. What I am trying to do is show a student's basic information at the top of the form and the student's career center session information at the bottom of the form. The student will have more than one session record related to it, but the form will advance to records not related to that student's record. How do I code the form to reflect the relationship that the tables have between each other in an object oriented format? For example, to point to the primary key of the first table: Students.strkey and the realtionship is linked to: Sessions.strkey. Any help would be greatly appreciated!