Increment number and enter multiple rows at once

Increment number and enter multiple rows at once

Hi,

I have an appliction in which I want to log engineering samples. The user will enter the sample details and the number of identical samples. I would like a script that takes the next available number and copies the sample details for each sample.

For example:

Last sample number used is 13520

User enters sample details (second prototype) and number of identical samples (10).

Script will take the next 10 numbers (13521-13530) and enter the sample details (second prototype) to each number so that each number has its own row in the database.


The database would then look like this:


|13520 | first prototype |
|13521 | second prototype|
|13522 | second prototype|
.
.
.
|13529 | second prototype|
|13530 | second prototype|



Thanks,

Adam