On Fri, 09 Feb 2007 16:39:52 -0600, Marshall Barton
<ma*********@wowway.comwrote:
>Dave White wrote:
>>I have created two tables to track my students' lessons.
Each student is responsible for most, but not all. of the lessons.
I've tried a junction table but I can't figure out an easy way to
assign one or multiple lessons to a student.
A common approach is to use a main form for the student data
amd a continuous subform for the junction table. The
subform's Link Master/Child Fields properties are set to the
studentID field. The subform would have a combo box with
RowSource to the Lessons table.
Thanks Marsh for the above input and a great learning experience. I
still, however, have a lot to learn about Access.
--------------------------------------------------
I set up the the form/subform as follows:
My main form is the Student Table
A Junction table subform was set up which contains its own ID plus all
the fields from the Student and Lessons Tables
I made it a continuous form and set the link Master/Child Fields'
properties each to the StudentID Field.
I added a combo box pointing to the Lessons Table.
(1) If I change the StudentID in the Main Form Student Table it
updates only the StudentID in the Junction Subform but "not" Last
Name, First Name, Etc.
(2) If I use the Combo Box in the Junction Form to add a Lesson it
only changes the Lesson ID but "not" Lesson Type, Lesson Description,
etc.
How can I resolve (1) and (2) to enter all the fields for Students and
Lessons to update my junction subform/junction table?
Thanks in advance,
Dave