updating data

[Guest]

I have a very simple database with two tables. Each table contains similar
data. I have created an update query to match data that is exactly the same
in each table. The problem I have is when table1 contains a record twice and
table 2 only contains it once. The data is okay, duplicated are fine. The
query updates both records in table1, when I only want it to match it once,
with the record in table 1.

Any suggestions?

 

[Rick B]

Why are you maintaining similar data in two tables and then updating one of
them? You are not using the power of a relational database. You should
never need to update a table with data found in another. If the database is
built properly, and the relationsips are set, then the data will be stored
in only one place and relationships will be set up.

Post your data structure and we can help you clean it up.