I am developing a access database to record training courses. I have a table with staff details, and another with course details. I want all staff to attend all courses.
I want to be able to have an overview with all of the courses listed for each staff member where I can update their status for each course, i.e. course completed, waiting for a course or on-going support.
I created a master from with the staff name in a combo box, then put a sub form in with the courses but couldn't make it work.
I am pretty novice at this so any help would be appreciated.