Forms :: Asset Tracking When Items With Unique ID Transferred From One City To Another

I have a task of managing hardware assets like desktop, monitor, HDD, routers etc. Each item is marked with a unique ID.

These items could be transferred from one city to another city; so need to track that too.

1. There will be two tables

One (say AssetDetail) will have the following fields
RecordID
City
AssetID
Description of the asset (desktop/monitor etc)
ProductSerialNumber of the asset

Second (say AssetTransfer) will have the additional fields
NewCity
AssetTransferredDate

2. I only want to open a single form :

a) where on the basis of either AssetID or the ProductSerialNumber, I could open a particular record and edit it.

i) if the asset is transferred from city A to city B; then the "City" field value in AssetDetail table should change to "city B"(New City field value).

ii) At the same time, each asset transfer record should get appended to the AssetTransfer table even if the table has an existing record with the same AssetID or ProductSerialNumber.

3. Also need an option to make a new entry to the AssetDetail table from the above mentioned single form.