So I apologize if this is in the wrong forum, but I can't seem to come up with the correct terminology to explain what I'd like to accomplish, but let me start from the beginning:
I was given a project a few days ago to create an employee training database, and up until now I have never touched Access but I'm quite computer savvy and have been watching various tutorials, taking notes, and practicing, trying to come up with a system that will fix a logging problem right now but also make it easy for others in the future to go back, edit, add, remove, etc.
I have 74 job positions, of which have their own position training modules as well as annual department training associated with them. Thanks to these forums I've been able to piece together something simple. But my question is this:
I would like to make a form that when you enter in or select a department/job position will bring up only the applicable training for that specific job in that specific department, instead of forcing an administrator to have to scroll through every single one. So if I'm entering in a new employee or adding newly accomplished training I enter in or select from a drop down menu the department and position the employee holds, so for example someone who works in department 123123 as a Warehouse Worker sor"Warehouse Worker - 123123" (I have this set up in a calculated field) it will change the position modules and department training to reflect or show only those associated with that position. So is this possible and how can I accomplish it or what tutorials do you know that will help teach me?