Submitting records into a 2nd table
Forgive the question as I know it's been posted before - I wanted to pose it with my solution in mind.
I've developed a small set of records in a table, for a specific type of order - to be used by a very small number of users who will never need access to the 2nd table. It's basically a simple order form. What is the best method to submit the order data from the 1st table, usually just one record (the current record) into my larger 2nd table and have a new record created and populated with the info of the 1st table record?
Thanks for your insight.