Moving Data

[sponger02]

I'm creating a proposal generation database and am having an issue. I have
created (2) tables and am trying to move data from one to the other.
Essentially I have a product table that will be used for multiple proposals,
and have created a proposal table to store the product sku from the first
database. How do I get the product sku to copy from the product table to the
proposal table? I have created a form that will list all of the products in
one list box and want to copy over the products I select to another list box.

 

[Barry Gilbert]

If the fields are the same, you could simply copy from one table and
Paste Append in the other. The more flexible way is to use an append
query. Create a new query in design view, select the table you want to
pull records from, and then select Append Query from the query menu.
You then choose the table you want to append to. Map the fields and
click run.

HTH,
Barry