Editing a query with 2 joined tables

[chuckmg]

Am using Access 2003. I have a simple join between 2 tables based on a
common field in both tables. I am not able to add data to any field in one
of the tables via the query. I need to be able to update one table with data
from the other. What can I do?

 

[John W. Vinson]

Am using Access 2003. I have a simple join between 2 tables based on a
common field in both tables. I am not able to add data to any field in one
of the tables via the query. I need to be able to update one table with data
from the other. What can I do?

The table that you're going to update should have a unique Index, such as a
Primary Key, on the field used for the join.