Setting up a query to pull data from another table

[Guest]

Can anyone help me?

I currently have a table called "products" & one called "productslocation" I
have an autoform created on the table products.

I have a button on this auto form which I want to remove the data from the
table "products" and place it in the table "productslocation" I may be wrong
but to do this I believe I would have to do a query? Could anyone help point
me in the right direction?

Many Thanks!

 

[John Vinson]

Can anyone help me?

I currently have a table called "products" & one called "productslocation" I
have an autoform created on the table products.

I have a button on this auto form which I want to remove the data from the
table "products" and place it in the table "productslocation" I may be wrong
but to do this I believe I would have to do a query? Could anyone help point
me in the right direction?

How are the two tables related? Ordinarily one would NOT want to copy
data from one table to store it (redundantly) in another table! Could
you explain the purpose of these two tables, and why you want to do
this?

John W. Vinson[MVP]

 

[nanne]

These are 2 actions.
create a query to add and a query to delete with the same criteria.
Execute them in the right order. 1 add then 2 delete.
success

Nanne