Append query?? (1 Viewer)

[spalmateer]

Hi,
I have two tables that were related with a one to one relationship. I no longer need all the fields in one of the tables and I want to combine the remaining fields of that table into the first table. I'm trying to use an append query with no luck.

The method I've used is creating a new query with the old table fields that I want in the first table. Then I change the query to append and choose the table I want to append to (first table). Then I select the fields where I want to append the information to and run it. It ends up just adding the records at the end and not updating each record. Please help! Thanks in advance!
Scott

 

[Pat Hartman]

Append queries add new rows to a table. Update queries update the columns of an existing row.

To build the proper update query:
1. Modify the table structure of the main table to add the necessary columns.
2. Add the main table to the QBE grid. Then add the table that contains the additional columns.
3. Draw a join line that connects the two tables on their primary key fields.
4. Select the new fields from the main table.
5. Change the query type to Update.
6. In the update to cell of the QBE grid, type the name of the source field as it appears in the table you're getting rid of. Qualify the field names with the second table name -

[tbl2].[SomeField]