Create the new tables so entries made under custom asset management are consistent. Tables would be constructed in a fashion similar to tblStates and also made editable in a similar fashion. (see Asset Pages >> Asset States) During custom asset editing, the table field selections would be viewable and selected using a combobox.
This would allow for consistent data selection/representation in these fields. Currently, with manual entry, the same location (building/Department/Branch Office) could entered differently. (i.e. "Bldg 5", or "Building 5", or "Admin Building", or "Administration").
Ideally, the fields would groupable in the drill-down manner similar to custom ticket fields, so only Buildings/Deparments/Branches related to a specific location would be presented for selection.
