I am in the process of designing a database that tracks certain employees training history..
I created three tables; tblEmployees(PK -Employee ID), tblTraining(PK - TrainingID), Course (PK-CourseID)
My problem is that I created a form, and a subform.
But I cannot get both forms to be in Synch. Meaning once I select an employee, I will like the information propagated to the subform, listing the training history of the employee. I would also like to be able to additional training information for each employee. I feel that I am almost there, but I am not sure what I a missing.
Any help is appreciated at this point.