From: wanglo@mailinator.com   
      
   Hoo boy that one again.   
      
   This is a well known thorny problem, with difficulties in any database   
   environment,   
   not just Paradox.  Generating unique keys has been discussed many times on   
   this board.   
      
   See www.rdaworldwide.com and www.thedbcommunity.com for papers and resources   
   online.  Dennis Santoro has a product that manages unique keys.   
      
   Getting cMax and incrementing is one of the worst methods known.  It is very   
   slow and gets slower as the table grows, and it will not scale to multiple   
   users.   
      
   -Al.   
      
   Kenneth  wrote:   
   >   
   >Howdy,   
   >   
   >Using P9 with XP...   
   >   
   >I need to have a field in an MRO number entries in sequence.   
   >That is, the first entry gets a "1" and the second gets a   
   >"2" etc.   
   >   
   >I don't want to use a autoincrement type because the field   
   >is part of a key.   
   >   
   >I could run a query, get a cMax, and increment by one, but   
   >is there a simpler way to do the deed?   
   >   
   >Many thanks,   
   >--   
   >Kenneth   
   >   
   >If you email... Please remove the "SPAMLESS."   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)