Access 2003 - Linked Tables

I have a DB (Access 2003) which contains two tables each table is linked two
a seperate SharePoint site.

My objective is to keep the Table 2 columns updated by pulling data from
Table 1. Subsequently, I want perform this action without overwriting data in
Table 1, since Table 1 will always remain current.

Bottom line, I would like to be able to pull data from select columns from
Table 1 and write to specific columns in Table 2.

What is the best way to approach this design? I am certain Macros and/or
queries will apply here. I am just not sure exactly where to start.

I am very new to Access and any help would be much appreciated! Thanks.

By the way, the records contained within each table all have separate primary
keys and are all unique. Not sure if this adds value/clarification to my
question or not.

"jimpa" wrote:

I have a DB (Access 2003) which contains two tables each table is linked two
a seperate SharePoint site.

My objective is to keep the Table 2 columns updated by pulling data from
Table 1. Subsequently, I want perform this action without overwriting data in
Table 1, since Table 1 will always remain current.

Bottom line, I would like to be able to pull data from select columns from
Table 1 and write to specific columns in Table 2.

What is the best way to approach this design? I am certain Macros and/or
queries will apply here. I am just not sure exactly where to start.

I am very new to Access and any help would be much appreciated! Thanks.