asp.net - Syncing Changing across two db tables -

i have create ui application in user can search client/location combination , update it's location(or insert in case doesn't exists). there can several rows in table client depending on it's locations
these changes need made in 2 different tables reside on 2 separate databases.

create table clienttab1 (     clientid int     , location int     , identifier int identity )  /* separate db , doesn't have identity column*/ create table clienttab2 (     clientid int     , location int ) 

data:

clienttab1: 101     9   1 101     21  2  clienttab2: 101     9 101     21 

let's user searches for: client 101, location 9 , updates location location 3.
now, can update clienttab1 using identity column there no way me made same changes in clienttab2.
please advice on approach.
please note can not link 2 databases together.
thanks.

save old value location , use in update statement second update, eg.

update      clienttab2  set      location=3       clientid=101      , location=9;