Updating tables easily

[deeda67]

I have two databases that are set up exactly alike - one for each office (Corporate and satellite). The Satellite office will have to send us their updated project, Proposal, and change orders data (which are in three different tables) every week so Corporate can update their database for the Satellite office and Corporate will have to do the same for them.

What is the easiest way? I basically just want it to look for changes to the tables and then update the table accordingly. I need it very simple for them because they don't know Access. Any suggestions?

 

[KeithG]

What do you mean by changes to the table? Additional records or new fields?

 

[deeda67]

Most of the time yes, it would be only new records added, but there could be a case where the project, for example, was changed (say the scope of work changes and the fee would also change). So if I set it to only updated with new records added, then it would miss that change entirely. But no, there shouldn't be new fields or strange fields in the data they send back because both databases are set up exactly alike. Does that make sense?