A
Appache
I have three tables(Students and Courses and Results ). Students and Results
tables have a relation over StudentID and Courses and Results tables are
related over CourseID.
I also have a main form and subform. Main form shows student information and
subform shows the information related courses that student suppose to take.
When I add a new student all the courses from courses table will be
transferred to the Results table by a VB code. And subform will show that
courses. The problem is I cant transfer these courses unless user enters
Student ID and Student's major because students in a different major take
different courses. I also tried to use different form to add a student but
when I add one I couldnt refress my main form. My questin is how can I solve
that problem?
tables have a relation over StudentID and Courses and Results tables are
related over CourseID.
I also have a main form and subform. Main form shows student information and
subform shows the information related courses that student suppose to take.
When I add a new student all the courses from courses table will be
transferred to the Results table by a VB code. And subform will show that
courses. The problem is I cant transfer these courses unless user enters
Student ID and Student's major because students in a different major take
different courses. I also tried to use different form to add a student but
when I add one I couldnt refress my main form. My questin is how can I solve
that problem?