B
Bigideaguy
Guest
I've got three tables, one for members, one for training and a join table linked to other two both with a many to one relationship. I've been trying to create a form with a list box (multiselect set to simple, so I can sellect all memberin attendance) and subform there the training details will get entered (date, subject, etc.). Although I've different ways of accomplishing this, all me searching has lead me to believe that I need an append query.
The best I've done so far with the append query is copy records in the join table when there is data there to start, won't work at all when the join table is blank.
The append query reads like this:
Field: TrainingID:forms!TrainingRecord!TrainingID
Append To: TrainingID
and
Field: MemberID:forms!TrainingRecord!MemberID
Append To: MemberID
The table it appends to is the join table, "Training Attendance", which only has three fields, an auto# primary key, TrainingID and MemberID.
This database is for a volunteer fire brigade that I am a member of and if I can get the training attendance worked out, I would like to add another separate event (fire calls) that will need to two type of attendance, "on scene" and "standing by at the hall".
Any advice is greatly appreciated. Thanks
The best I've done so far with the append query is copy records in the join table when there is data there to start, won't work at all when the join table is blank.
The append query reads like this:
Field: TrainingID:forms!TrainingRecord!TrainingID
Append To: TrainingID
and
Field: MemberID:forms!TrainingRecord!MemberID
Append To: MemberID
The table it appends to is the join table, "Training Attendance", which only has three fields, an auto# primary key, TrainingID and MemberID.
This database is for a volunteer fire brigade that I am a member of and if I can get the training attendance worked out, I would like to add another separate event (fire calls) that will need to two type of attendance, "on scene" and "standing by at the hall".
Any advice is greatly appreciated. Thanks
