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...