Qrew LegendCan you tell me more about your relationships.
Is the table called Trainings really "Employee Trainings" which has a relationship to both the Employee and a Training Type Master table?
If I were setting this up I would have these tables
Employees
Master Training Topics
Employee Trainings
Master Profiles
Profile Trainings
Employee < Employee Trainings > Master Training Topics < Profile Trainings > Master Profiles.
Is that your setup? In my notation above it reads like One employee has many Employee Trainings.
Hi Mark,
That is probably what I am missing, I don't have that many tables setup. I will go ahead and do that and see where that takes me. Thank you.
