I am trying to create a training course sign up sheet and I have run into a dead end. I want to have the courses listed (as records) so I made the table (training) with the fields; Course ID , Date, Location etc. Trainers can now go in and create the course and users can see the available courses. Now I want to allow users to enter their name to "sign up" for the course so I created a Students table and added fields for Name and Course ID (the course ID will match the course ID in the Training table so that it can determine which students are signed up for which class). How can I add the field that allows the entry of the student name and Course ID into the Student table. I will also need to have the Student list available for viewing (from the students table).

I may have to use some scripting or queries, but I would be interested in hearing some possible solutions. - Thanks!