Search results

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"...