I'm building a database that will be used to track the professional training and development courses employees take at my work. I'm relatively new to db's, and I find the relationships a little confusing to grasp in this case.
I have attached what i've done so far.
I believe i have created the right tables but that I have made a mistake in the relationship.
I think the relationships are many-to-many, but I have managed to put one-to-many and not sure exactly how to switch it to many-to-many
At the end, I plan on having a form with a subform that allows the user to view the courses and individually add people to that course.
Your help, input and advice would be greatly appreciated.