Hi, I'm very much a beginner with Access 97 so please be patient!
I'm creating a database to show skills, knowledge and training of employees. I've got two tables, one called EMPLOYEES and the COURSES. The fields are as follows:
EMPLOYEES
EmployeeID
Name
Telephone
JobTitle
COURSES
CourseID
CourseName
Date
Certificate
Now, one employee could go on several courses, and each course could have several employees on it. I've created a "link table" between the two tables called EMPLOYEECOURSE.
EMPLOYEECOURSE
EmployeeCourseID
EmployeeID
CourseID
and then linked (via the relationships) the EMPLOYEE table to the COURSE table via this new table...make sense so far??
What I'd like to be able to do is create a form for the user to enter employee's details then to, by way of a subform, to enter the courses he/she has been on. I assume I'd enter the course details in a seperate form, then link somehow in the subform only the courses that particular employee has attended...but how??
I'm sure its really easy but I'm pulling my hair out here, any help will be greatly appreciated.
Regards
I'm creating a database to show skills, knowledge and training of employees. I've got two tables, one called EMPLOYEES and the COURSES. The fields are as follows:
EMPLOYEES
EmployeeID
Name
Telephone
JobTitle
COURSES
CourseID
CourseName
Date
Certificate
Now, one employee could go on several courses, and each course could have several employees on it. I've created a "link table" between the two tables called EMPLOYEECOURSE.
EMPLOYEECOURSE
EmployeeCourseID
EmployeeID
CourseID
and then linked (via the relationships) the EMPLOYEE table to the COURSE table via this new table...make sense so far??
What I'd like to be able to do is create a form for the user to enter employee's details then to, by way of a subform, to enter the courses he/she has been on. I assume I'd enter the course details in a seperate form, then link somehow in the subform only the courses that particular employee has attended...but how??
I'm sure its really easy but I'm pulling my hair out here, any help will be greatly appreciated.
Regards