G
Graham
Hi need a bit of help
I'm designing a database to record staff taking courses.
I've got a staff table listing all the info about the staff members and I've got a courses from which list each course the staff can take.
I've designed a form that takes this info and saves it to a table which is then appended to a completed course table using an append querie via a button on the from.
What I need is to put a subform into the form and when a staff member is selected and say for example the Word Beginner level course is selected that the staff name The Word intermediate, Expert and refresher is automatically filled into the sub form and the same will happen when Excel is chosen Access etc.
I'm designing a database to record staff taking courses.
I've got a staff table listing all the info about the staff members and I've got a courses from which list each course the staff can take.
I've designed a form that takes this info and saves it to a table which is then appended to a completed course table using an append querie via a button on the from.
What I need is to put a subform into the form and when a staff member is selected and say for example the Word Beginner level course is selected that the staff name The Word intermediate, Expert and refresher is automatically filled into the sub form and the same will happen when Excel is chosen Access etc.