From: NSpamPlease_rodney1@bellsouth.net   
      
   Joe,   
      
   Also note... if a transaction history has been established for one of these   
   items... such as "16L0A1061A"... then your historical reporting will be all   
   wrong.. because the sales data was based on that item number.   Your   
   inventory values and totals will be all wrong too.   
      
   Typically, it should be impossible to delete an inventory item once a   
   transaction on it has occurred... such as purchase or sale.  Doing so will   
   effect the entire system.   
      
   If you change the item number, it will also have to be changed on every   
   invoice, sales reciept, historical report, etc., etc., etc...   That is whay   
   it is illadvised.   If a customer would bring one of these items back for a   
   refund, their reciept will no longer have a valid item listed on it.   
      
      
   --   
   ...   
       `·.¸¸.·´¯`·.¸¸.·´¯`·->  rodney   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)