Updating changes in a table from another table.

[royca]

Hi All, I have a number of assets at a number of locations. Assets are sometimes added, moved, or removed. We have a master tracking list with the location of each asset. I have a maintenance tracking list that I would like to have update automatically from the master list. All the data is in tables.

I would like to update the location for moved assets, remove assets without locations, and add new assets that have received a location.

Is there an eloquent solution to this problem? I would appreciate any ideas.

For example,

Location Asset Data
loc_01 202 202
loc_02 203 203
loc_03 400 400
loc_04 401 401
loc_05 402 402

May become,

Location Asset Data
loc_01 400 400
loc_02 500 500
loc_03 202 202
loc_04 203 203
loc_05 402 402