added view items by customer, customer's items
made acct #s unique, adjusted data types and added status