Create multiple records from a single interface...

[FMmomo]

I am attempting to expedite data entry for our database of biological samples. Every sample becomes a unique record, however, there is information that is common to groups of 25 samples.

I would like to design a layout that collects the common information from the user (Box_ID, Population, Date, Species) and creates new records for all 25 samples each with a unique DNA_ID. DNA_ID is a 6-digit number preceded by the letter of the species it represents (say, M000123). Ideally, the script would automatically retrieve the next available DNA_ID for the species identified on the data-entry layout .

Any assistance is much appreciated. Thanks.