Automatically, no.
What I would do in this situation is create reports to limit manual search work. If you create asset pages for spare hard drives that have their own serial number, you can create a report which compares the serial number of a hard drive assets with the hard drive serial number scanned from computers. When you get a match, this would mean that the spare hard drive is now in the computer.
For the use case where it is the other way around, if you create asset pages for old hard drives that are replaced, you can do a comparison with tblfloppyHist which keep historic serialnumber data. So if you get a match there, the hard drive was in that computer at some point.