Create a "New Order" that copies an existing order

[Nelz]

I have multiple forms, and tables that when linked together make what the customer calls an "order" If a client places a re-order of something they ordered in the past, I would like to locate the order using the entry form (no problem) and use a re-order button to duplicate it, with its new Autonumber. Problem is, the information that makes up an "order" is contained on multiple tables. The Order Table, the order details table, and even a third sub-detail table. I've tried a roundabout process of duplicating the detail record then going back to change the orderID field to match a new order, but its really messy, and not good. Any ideas???? Please, I've been up for about 15 hours trying everything.