Hi
I have a list of students undetaking various sports activities.
Currently the students are listed in tblGroupMembers and I manually go
into a form/subform and allocate each activity for each student pulling
the activity name from a combo sourced from tblActivities into a new
record within table- tblAssessmentActivity. There is a one-to-many
relationship between tblGroupMembers and tblAssessmentActivity so that
Student A ends up with records for Tennis, Golf, Football etc.
So- what I would like to do is "simply" list a student or a group of
students, list the series of activities that they will do and press go
and the database automatically creates all the new activity records per
student.
Is this possible? If so please advise.
thanks
David