Editing a query with 2 joined tables

  • Thread starter Thread starter chuckmg
  • Start date Start date
C

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?
 
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?
Click to expand...

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.
 
Back
Top