We currently use a form to insert order information from our manufacturing line into a mysql database. We have a simple form with 4 input form boxes that we place part number, order number, price and serial number into. Since much of this information is repetition except the serial number, I would like to create a new form that you would put in the part number, order number, price and quantity that would then go to another form that would ask for just the serial number. Upon filling in the serial number it would submit the information into the database and retain the part number, order number, price until the quantity of submitted serial numbers is equal to the quantity. I have attached my existing form.