Updating Data on Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a Database to keep track of what classes are needed by
students for graduation, and how they are progressing toward that goal.

Students are on different Tracks. so I have set up a Table containing those
Tracks.

Within that Table (Plans), there are 8 English Requirements over a 4 year
period. (similarly:,8 Math Requirements, 6 SocSt Requirements etc).

I've identified these as Eng1, Eng2,Eng3 etc. where I have entered the
appropriate course number based on the Track.
There is a field for the Track (CollegePrep, Technical, ESOL, etc.)
Now I have another Table, (StudentPlan) which is almost identical, except
that it has the Student ID number as the Primary field.

I have a drop down in the Track Field for the student that reads from the
Plan. I would like for the remaining fields in the StudentPlan to populate
when a track is selected for that student.

Any help will be greatly appreciated.
 
How can I get the StudentPlan fields to populate (from the Plan) when I make
a choice in the ComboBox titled "Track"?

The combo box reads from the "Track" field which comes from the Plan. Once
selected, it would populate the "Track" field in the StudentPlan (This part
was easy). What I also need is for each of the core academic areas to also
poplulate with the corresponding (thisis the hard part).

For example, if the Honors Track was selected, then all of the other fields
in the Student Plan would populate with the corresponding fields from the
Plan. So, for the Eng1 field in the StudentPlan, it would populate the
Honors English Sem1 Course from the Plan's Eng1 field, Eng2 field would
populate with HonorsEnglishSem2 etc.
 
Back
Top