Mass changing a field in an asset record
We use our Asset inventory to track all computer orders even after they've been long retired, one thing we need to be able to do if possible is to be able to make a mass change to a particular field, I will describe the situation. One of the fields in the Computer asset type is "technician" which currently is set up as a Multiple Select field type. The problem is that we'd like to be able to make a change to one of the techs names (if we hire a replacement) and have it populate through the database without requiring an export to CSV, changing all the fields in the CSV file, then re-importing. My understanding is that we should be able to make this happen possibly by creating a new asset type called "Asset Technician" and then populating THAT with technician names. My problem is that I'm not sure how to do that properly.
If i Create a new asset type called "Technician" do I then create individual Asset Fields with each being the name of one of our techs? Do i Set a default value? What do I set the type to? Am I even sniffing up the right tree as how to best accommodate this situation?