Adding tables

[tmarsh]

I have a database that tracks staff training in a health trust. It's pretty simple, tb_staff, tb_courses_done which is 1:n and a tb_courses 1:n on the staff_id of tb_courses_done.

I want to know how to go about adding a table(s) that will allow me to book staff onto courses and track if they attended or not. At present it's 1 staff member has many courses so any courses entered are "done." I have a main form with staff details and it has a subform where I add completed courses.

Hope that's clear?

Thanks.

 

[llkhoutx]

What you want is a junction table to hold StaffID (one) and CourseID (many).

The CourseID comes from the couse table which has CourseID, CourseDescription, etc.

This way you pick a staff member and can easily display all the his/fer courses in a subform.

Draw a picture of the tables and you'll see how they're related.