Originally Posted by melodyh40
I was pretty much an idiot when I sent it up originally and, for that database, there's no turning back now.
I wouldn't say Idiot, not by a long shot. Not versed in data normalization, but if it accomplishes what you need, definitely not an idiot.
It also isn't to late to go back and update. I'd check to see if there is a requirement for each of the classes to actually have a "Completion date" or a "Class Number" or other such unique identifier. If this is a requirement, HR will normally want enough to identify and verify compliance.
You CAN create a query your existing table to add the new child records. It would insert in to the child table each employee number and a "ClassID" that you hard code in, but you would use a where clause for the matching field in your existing table to drive this.
For future design needs, do any of the classes employees have to take expire? I deal with Nurses, so we have to track medical training and health records that often need to be renewed yearly or every other year.