update records from one table to another

[paulevans]

Hi

This may seem a really dumb question but I just can not get my head around the best way of solving it.

I have two tables orders and orders_tmp
the table orders is created form the orders_tmp table. The order is created by a single field createorder (yes/no)from the order_tmp table. I run an append query to copy the records into the orders table. this woks fine.

The problem I am trying to solve is how do I now go back and change the order for what ever reason. I need the order_tmp table to now also include my existing order.

Help please

 

[stopher]

Why are you using two tables? This is a very bad idea. Put all your data in the one table (assuming it's normalised)and your problem goes away.
Chris

 

[paulevans]

I really don't know why I am using the tmp table except that it keeps the exisitng records as they were. An order may be issued to one or more people for the same bit of work and so thought it would be easier to keep track this way?