I haven't been able to find the best way to search for this question, so I'm hoping I can explain it properly. My situation is I am making a form to document work orders. One work order can contain multiple unique serial numbers.
The serial numbers are broken up into 3 parts; a 4 digit Model identifier, a single digit series indicator, and a 4 digit serial number.
The basic function I am looking for is the user inputs the Work Order number, then inputs the Model, Series, and number of units. Once they hit submit, I need it to add x amount of records with only the serial number changing by +1 for each record. This means it needs to know the last serial number for that model and series, and start with the next one.