help with Combo boxes, I think???

  • Thread starter Thread starter edith
  • Start date Start date
E

edith

I am a relative newcomer to Access. With the help of a few experts on this
forum, I successfully managed to build a database a year ago for a project
and need to do another one but can't remember a lot of what I learnt last
year...! I would really appreciate some more help.

I have a table with class details. There are several different fields (eg
day, time, venue, teacher, subject, level).

I have another table and form with the student details. I now need to go to
each student record and enter the classes they attend (i have the classes as
a subform on the student details form).

From the class subform on the student record, I need to be able to go to
ClassID and get a drop down box that will show me the full details for each
class
eg ClassID 1 = Monday, 10am, Maths, Room 3, Mrs Brown, level 2
At the moment, I go to the ClassID and just get a drop down box with a list
of numbers which are meaningless.

I know I manged this last year but can't for the life of me remember
how....!!! Sadly I don't have much time to get this database built, and I am
sure it is an easy solution...



Thanks
Edith
 
Edith

If you built one last year, have you looked at it to see how you handled it
then?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi Jeff,

When I did last year's it was on someone else's pc which I no longer have
access to (forgive the pun!), and stupidly I didn't keep a copy for my own
learning!
 
Edith

If I understand correctly, you have a one-to-many relationship between
classes and (enrolled) students.

One way to handle this is to use a main form based on the class, and a
subform based on the enrolled students.

This implies three tables ...

tblClass

tblStudent

trelEnrollment

Is this how your data is structured?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top