From: greens@diamondsg.com   
      
   never, never, never do a changeto or an uncontrolled scan on the key fields   
   of a table.. what you get will NOT be what you expected, in many cases.. in   
   this case, you're creating key violations / duplicate records, because the   
   changes are being made one record at a time..   
      
   make a copy of the table, unkey it, make the changes, then rekey and reindex   
   when you're done..   
      
   --   
   Steven Green - Waldorf Maryland USA   
      
   Diamond Software Group   
   http://www.diamondsg.com/main.htm   
   Paradox Support & Sales   
      
   Diamond Sports Gems   
   http://www.diamondsg.com/gemsmain.htm   
   Sports Memorabilia and Trading Cards   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)