add multiple records in a table by fetching data from another table

[drriyazq]

i have two table. one has field customerid & orderqty
other table is invoice table where i want invoice generated automatically from first table depending upon order quantity. other table has field invoiceno, customerid,date,amount.
i want a form to have rate submitted and then multiple invoices created in the invoice table with help of rate and orderqty