I have a table called CourseCollege Dates containing 3 fields: Course ID, Start Date and End Date.

I also have a table containing all details on the candidates for this course.

In the candidate Form which is used to enter in all the details, i have a subform, in this subform i want to be able to enter the Course ID '1' and the rest of in the information (start date and end date ) to automatically appear.

At the moment it just displays both sets of course details.