T
Tim
I have two tables. The first one is tblStu, that has StuId as a primary
key(PK), a TeacherId non-PK, and other stud-related fields. The second one is
tblTeacher with TeacherID is a PK and other teacher-related fields.
I have a form that bounds to this tblStu and a combo box that bounds to
tblTeacher. Originally, a student is assigned to a teacher. However, I'd like
to re-design my form so that a student may be assigned to more than one
teacher. My questions are following.
1. Do I need to create a new (second) combo box to help a user to select
another teacher? What should I do?
2. Should I make change to the tblStu structure, i.e., add a second PK to
TeacherID in tblStu besides StuID?
Thank you for your help in advance
key(PK), a TeacherId non-PK, and other stud-related fields. The second one is
tblTeacher with TeacherID is a PK and other teacher-related fields.
I have a form that bounds to this tblStu and a combo box that bounds to
tblTeacher. Originally, a student is assigned to a teacher. However, I'd like
to re-design my form so that a student may be assigned to more than one
teacher. My questions are following.
1. Do I need to create a new (second) combo box to help a user to select
another teacher? What should I do?
2. Should I make change to the tblStu structure, i.e., add a second PK to
TeacherID in tblStu besides StuID?
Thank you for your help in advance