1. A computer-enabled method for efficiently displaying a veterinary hospital customizable administrator view of veterinary pharmaceutical and other animal related product item records, the administrator view comprising a schema defining a unique item identifier field, a plurality of fields corresponding to fields in a centralized pharmacy managed products database and a plurality of fields corresponding to fields in a hospital managed database, comprising the steps of: creating an item record in the administrator view from the schema with each of the plurality of fields being undefined; retrieving and storing into the item record in the administrator view at least one item record from the products database, the item record including at least a unique item identifier field, a prescription required field, a price field and a name field; searching the hospital managed database for a corresponding item record for each matching unique item identifier field to the at least one stored administrator view item record retrieved from the products database; and for each corresponding item record found in the hospital managed database, adding at least one field of the corresponding item record to the administrator view item record.