I have a database for tracking tutoring referrals at a school.  Teachers currently select a student name from a dropdown menu, which is a lookup field from another form.  They also enter a written description of the assignment in a text field.

I would like to be able to choose multiple students from a mult-select field and enter the description for the assignment in the text field -- and have the database create a record for each student selected in the multi-select field. 

Or... could it be possible to add a submit button that would save the information and bring up a new record with the same data in all field but student name?  Thanks!!