Combo Box

[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!

 

[Guest]

-Your Table Courses should have a Primary key where the 1,2,3 field is.
-On your form, base the information for the student in the student table,
not a query combining courses and enrollment,
-Use Parent and Child link fields to connect your main form with your
subforms, I recommend you read about relationships and subforms in the help
file,

 

[Guest]

Thanks so much for your help! It is greatly appreciated.