Cop a single record to existing table

[torquay]

Hi I am trying to copy a single record from one table to another
Heres what I have
I have a suppliers table, suppliers order table and suppliers orders detail table
I use this to generate an order for the supplier, however the single order does not always arrive at the same time (the order is sometimes fragmented and can show up days or weeks later)
I show the order from a query showing info from the above 3 tables in a form called Suppliers Order
The form has a sub form of the order showing whats been ordered in datasheet view so i can see all items on this particular order
However when the partial order arrives I would like to run a query just to add whatever arrives into current stock (Inventory table) and grey this out on the order form what has arrived so it cannot be added again from the suppliers order form but the other items on the order form are still showing until they also arrive and are then added to current inventory
Hope this makes sense
Of course I am probably completely missing the point here and making work for myself
Any help would be appreciated as the head hurts now
Thanks
Kim

 

[Ranman256]

Use an append query. Use the key in the source as criteria in the query.

 

[torquay]

Thank you for your answer can you give me an example please

 

[Ranman256]

insert into table2
(field1) select [field1] from table1 where [id]=234

 

[Ranman256]

use the query wizard.

 

[Minty]

You probably should have a qty arrived field and use that to calculate your outstanding order quantities.

Likewise your Inventory should be based on stock in minus stock out, don't try and store it as a value.