What table occurrence is the worksheet based off of? Seems to me like you may be duplicating the parent record and not the child record. Without more information, I dont think we can accurate assess you situation.
I'd check out the structure of your database carefully. I can't tell from here, but suspect that you have fields in your layout from two or more tables. WHen you duplicate a record the current record in the table that is referenced by your layout is duplicated, but the data in other related records remains unchanged. Because the key fields in the duplicate record are the same as those found in the original record, they both point to the same set of related records. Thus, changes to these fields from related records will appear on both original and duplicated records.
To do what you want, you'll need to learn more about how your database is designed and use a script to duplicate the records in each table and update the key fields in new main record to link to the new copies.
There are two different tables (CMSStudent and CMSWorksheet) - the CMSWorksheet fields are being viewed in the CMSStudent table.
I will need to come up with some sort of script to duplicate both, then.
Shouldn't duplicate the student record, just the worksheet. So multiple worksheets can be tied to a single student.