Table to table data transfer
I have an invoice table in my database that was created incorrectly initially. I didn't use a separate table for the item list. The item list and invoice is in the same table. The items use repeating fields up to 40 repetitions and are not in a portal. It works ok but the primary problem is if I have a multiple page invoice I have to create each page in a separate invoice.
Anyway, now that I have learned that I need 2 tables for the invoice I am preparing to recreate the tables. My question is after I create the new tables for invoicing is will I have trouble copying or moving the item data from my old invoice table to the new "itemlist" table? I have nearly 3000 quotes & invoices in the database with anywhere from 1-29 items per invoice so I don't want to have to manually move all that data. If I have to I'll just archive the old records and start a fresh set but I'd rather have them integrated. I've noticed that if I try to export an invoice to Excel it does not use all the data so I'm concerned that the items will not all export into the new table properly either.
Thanks for any help.