Updating a Table

[lienlee]

I have a table and it has 2 look up columns.
I want to be able to update all the columns based on 2 other columns in 2 different tables.

Append query works, however, the old data stays. I want to erase all the old data and fill the 2 columns from 2 different tables.

I've done update query for 1 to 1 table. but is it possible to use 2 tables to update 1 (its a look up table..so yea)

[OBP]

Sorry, I am not quite clear what you need to do. Normally "Lookup" fields (Column) automatically update when the Looked up table is updated. You can run 2 queries to update the 2 fields or if the Relationships allow it you can run one query with both tables.