Search results

The Order ID is already assigned in the Order table. I just want to "paste" some records from the basket table along with the ID from the Order table.

I have an order system whereby there is a "basket" table and an order detail table. I want to use an append query to move all the records from the basket table to the order detail table. However, I also need to mark each record that gets appended to the order detail table with an "Order Id"...