Training Database

[UT227]

I'm building a training database for my work. The main tables I have are: Classes Table, Schedule Table, and the Roster Table, and Names Table. The Classes Table have a list of all the classes offered. When a class needs to be scheduled, it is put into the Schedule Table. The Roster Table is to make the actual table and holds the scores. I want to be able to choose students from the Names Table and populate the Roster Table. I was hoping for ideas on how to do this. Right now, I'm blank.

[ranman256]

Take a form,have a list box on the left of all names, tNames table. (LstNames)
make a combo box of the classes, so user can pick a class. CboClass.
a list box on the right to show the names on the class of the cboBox.(lstRoster)

make a select query runs and shows in the lstRoster looking at the cboClass
when user picks the class combo, update the lstRoster from the cboClass AFTERUPDATE event.

sub cboClass_afterupdate()
  LstRoster.requery
end sub

now add to this list by dbl-clicking on a name in the lstNames. This fires an append query using the items on the form.
docmd.openquery "qaAdd1name2Roster"

this query looks like:
insert into tRoster (studentID, ClassID) values (forms!myForm!lstName, forms!myForm!cboClass)

[orange]

You may get some ideas from this free data model from Barry Williams

It's a little different but deals with some concepts that should be helpful.

Good luck

[UT227]

ranman256,
I have been sidetracked for a while. It looks like that's exactly what I'm trying to do. I'm still a novice at this. I didn't quite get this, "a list box on the right to show the names on the class of the cboBox.(lstRoster)" The first 2 items were simple. I'm not understanding this list box. Do I make another table for it?

[Homegrownandy]

If you put a listbox on a form in design view you can follow the wizard to find the records you wish to show.