How to Syncronize two fields in two tables

[srik1812]

Can any body give me an idea how to sync two fields in two different mdb tables but identical fields. For example on mdb project component is having opening stock and another mdb project component1 has the same field with empty data in some items and some are filled up.

Thanks

[ADezii]

Assuming both Tables containing this Field have the same Primary Key:

1. Link the External Table.
2. Create a Query and define a Relationship between the Primary Key Fields of the Local and External/LinkedTables.
3. Synchronization would now be a simple matter of executing an Update Query or Queries such as in the Criteria Row of the Local Field:
   =[Linked Table].[Identical Field]