By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

How to Syncronize two fields in two tables

P: 1
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.

Aug 17 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,669
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]
Aug 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.