open two connections<BR>one to the remote one to the local<BR>select from remote update to local<BR><BR>Linking data from two sources can be complex you can have interesting senarious.<BR><BR>Local db has records added, updated, deleted<BR>Remote db has records added, updated, deleted<BR><BR>what you need is transaction tables<BR>i.e. for each event write or delete you create a transaction record. Then you need to decide which DB has precidence. IF local DB deletes a record and Remote updates what is the state of each DB? They should be the same in the end!