July 26, 200421 yr Newbies 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.
Create an account or sign in to comment