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.

---

Reply from Alex Hedley:

Classes | Schedule | Roster | Names

What Scores go in the Roster table?

The Access Work Order Seminar covers Scheduling using a DLookup at current appointments so you don't set them at the same time.