Parent and child forms/subforms

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top