J
Joseph
I have three tables that I have linked together for our training/:
Training: TrainingID, TrngCrsId,StaffId,DTG,Instructor, Memo
Training Courses: TrngCrsId,Topic, Hours, Level, EmpOrent, VoluntOrient
Staff: StaffId, Last, First, Middle, etc......
The problem is that I have lost my mind on how to link in a form/subform to
have the topic, dtg and instructor as the parent and staff as a datasheet
subform. Having two table makes this easy, but using three is .......
I have to put the DTG(Date/Time Group) and Instructor in another table
because we have several persons that will teach the same topic. So instead
of having different records for each topic with each DTG with each
Instructor, I said ok, normalize the topics. And then enter the DTG and
Instructor for each class.
I just want to know how to link using form / subform between the Training
table (using the Training Courses table) to the Staff table as the subform.
Training: TrainingID, TrngCrsId,StaffId,DTG,Instructor, Memo
Training Courses: TrngCrsId,Topic, Hours, Level, EmpOrent, VoluntOrient
Staff: StaffId, Last, First, Middle, etc......
The problem is that I have lost my mind on how to link in a form/subform to
have the topic, dtg and instructor as the parent and staff as a datasheet
subform. Having two table makes this easy, but using three is .......
I have to put the DTG(Date/Time Group) and Instructor in another table
because we have several persons that will teach the same topic. So instead
of having different records for each topic with each DTG with each
Instructor, I said ok, normalize the topics. And then enter the DTG and
Instructor for each class.
I just want to know how to link using form / subform between the Training
table (using the Training Courses table) to the Staff table as the subform.