G
Guest
Hi!
I'm quite new to this and am struggling with something. I've looked through
the posts, but still am not clear.
If have a listing of courses that never change that are contained in a
Courses table. I have linked this to an Enrollment table, to which a Student
Info table is also linked. This works fine.
I created a query with the student name, course and enrollment info and
based my form on this. I want to display a family name, the student names
from that family - no problem. The sub-form contains the course name and
details which is pulled from the query.
My question is: I used a combo box to be able to select courses for the
students (they may attend more than one). This works fine, except that it
starts adding 1, 2, 3, 1, etc. to the Courses table, which is linked to
Enrollment.
Should I be trying to populate the Enrollment table with the courses each
student is taking, or am I taking a totally wrong approach.
Thanks!
I'm quite new to this and am struggling with something. I've looked through
the posts, but still am not clear.
If have a listing of courses that never change that are contained in a
Courses table. I have linked this to an Enrollment table, to which a Student
Info table is also linked. This works fine.
I created a query with the student name, course and enrollment info and
based my form on this. I want to display a family name, the student names
from that family - no problem. The sub-form contains the course name and
details which is pulled from the query.
My question is: I used a combo box to be able to select courses for the
students (they may attend more than one). This works fine, except that it
starts adding 1, 2, 3, 1, etc. to the Courses table, which is linked to
Enrollment.
Should I be trying to populate the Enrollment table with the courses each
student is taking, or am I taking a totally wrong approach.
Thanks!