Is there a way of inserting a record into a database and at the same time copying the data from the form to another page?
I have to tables in a database that are related. One stores customer details and the other customer orders Both have an auto incremented ID field.
The customer enters their details into a form which is uploaded to the customer details table. The customer then needs to enter their order details. The customer can have up to 2 orders.
The problem I have is that once the customer has entered their details, I need a way of finding the ID from the customer details table to store in the customer orders table. I don't want to get them to re-enter their details in order to search for the ID field in the customer details table.
Any ideas?
