i don't know if you want to be able to print an invoice or not this is one way to do it.

1 add your two tables Orders with orderID,CustomerID,CustomerName,CustomerAddress,OrderDate and...