I have a table that is basically a homework submission table. I made a form for it.

Say a record lists the assignment (Homework #1) and I have 3 records for this. One each for Peter, Paul, and Mary.

My idea was that they would submit the form, pick Homework #1 and their name from the dropdown, and that when they finished submitting it, that record would go into the record that was waiting. Instead, it maks a new record.

How could I have that information go into the existing record?