I am developing a database to keep track of employee safety trainings. Each employee will have multiple safety trainings on a specific date. Will I need to set this up as a one-to-many or a many-to-many relationship? I will want to search by employee (to see what training they have had), by safety training (to see who took each training), and by year (too see what training was done that year). I think that the training 'events' should be organized in a table as a log of training, like the contacts in your example. However, will that be the best way to set my database up to search by Employee, Training, and Year? It seems that this may be a many-to-many relationship since multiple employees will have taken the same trainings.

---

Reply from Richard Rost:

What you have here is a MANY-TO-MANY relationship. You have a table of employees, a table listing all of the available training classes, and then a junction table to track which employees took what classes on which dates. I cover this kind of relationship in detail in my Access Relationships Seminar.