populate one field from another

[Guest]

I have 3 tables... tblPersonnel, tblAssets and
tblHistory. I need to populate
[TransferredFrom] and [DateTransferred] in tblHistory
from the values in
[PersonnelID] and [DateAssigned] respectively from
tblAssets. (PersonnelID is a combobox concontinated to
show first and last name)Thereby each new
holder of that particular asset and the date he acquired
it will be transferred
to tblHistory whereby creating a record of the different
holders and dates of the asset.
Also must tblHistory be assigned a primary key?
Really appreciate your help