Not sure how or if I can do the following:

Not sure how or if I can do the following:

I'd like to create a database to track assets.  I have a couple of questions.

For example, under asset, I might enter Asset Type, (Server), Serial Number, Model Number and Vendor (Dell).

If we want to track asset history, would it be possible to create a table that has a given record, say like below
Type        Model #      Serial #      Vendor      Purchase Date     Purch. Price      Location          Notes
Server      12345          54321         Dell            1/10/2012             $5,000          NJ DC      Imaged to Linux

And then if I added another entry for this host, matching model #, serial # and vendor, it would copy the old entry to an asset history table?


Also does Zoho allow for the support of composite fields, that is a field that is made up of multiple other fields, say a combination of asset type, serial number, model number and vendor?