How to Look Up Values From One Table and Automatically Insert Them in Another Table in Access 2003
An append query automatically looks up fields that you select in one table and attaches them to another table within the database. Be careful though--once you make the attachment you cannot easily undo it.
Other People Are Reading
Instructions
-
-
1
Start Access and open the database that you want change. From the database window, click "Queries," then "Create Query in Design View."
-
2
Select the table or tables that have values you want to look up from the "Show Table" window. The table that you select will appear in the "Select Query" window.
-
-
3
Pull down the "Query" menu from the main toolbar. Scroll down and click "Append Query." This opens a box that allows you to choose the table in which you will be inserting the selected values.
-
4
Enter the field that you want to attach to another table. Use the pull-down arrow to fill in the "Append to" box. Close the "Append Query" window and save the query.
-
1
Tips & Warnings
Make sure that the data type of the field that you are moving matches the field to which you are moving the values (a text field to a text field, for example). Access will warn you if the data types do not match.
Once you have run an append query, you cannot undo the changes made to the table with the "Undo" button. Double-check that you want to move the values from one table to another before saving the query.
