Hi all,
I'm designing a db in which I have a list of teacher names, and for each record (each teacher), there is a list of subject that this teacher teaches.
what i did is the following:
I have designed a form with teacher name, and a form for subjects.
I have added a button in the teacher form, next to each teacher name, this button we take the user to the subjects form to add the subjects for this particular teacher.
To link these to form, I have added the primary key of the teacher table (TeacherID) in the subjects table, so the relationship is one-to-many.
but I couldn't get to connect them.
I want the subject form to get the TeacherID from the teacher form to connect each teacher with his subjects. How can I do that?
Any help will be very much appreciated.
Best Regards,
CS.
I'm designing a db in which I have a list of teacher names, and for each record (each teacher), there is a list of subject that this teacher teaches.
what i did is the following:
I have designed a form with teacher name, and a form for subjects.
I have added a button in the teacher form, next to each teacher name, this button we take the user to the subjects form to add the subjects for this particular teacher.
To link these to form, I have added the primary key of the teacher table (TeacherID) in the subjects table, so the relationship is one-to-many.
but I couldn't get to connect them.
I want the subject form to get the TeacherID from the teacher form to connect each teacher with his subjects. How can I do that?
Any help will be very much appreciated.
Best Regards,
CS.