Hi all
I'm creating a database which will record the attendees of training courses. I've created a table for the attendees names and details, and a table for the courses.
I want to be able to create a form for the courses, on which there is a sub form where you can type in the attendees details. However I've no idea how to accomplish this. I've created the subform but I want it to only show the course attendees for that particular course, not every attendee.
I'm probably missing something obvious, but any help would be appreciated.
Regards
I'm creating a database which will record the attendees of training courses. I've created a table for the attendees names and details, and a table for the courses.
I want to be able to create a form for the courses, on which there is a sub form where you can type in the attendees details. However I've no idea how to accomplish this. I've created the subform but I want it to only show the course attendees for that particular course, not every attendee.
I'm probably missing something obvious, but any help would be appreciated.
Regards