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?