From: usenet@soleSPAMLESSassociates.com   
      
   On Sat, 08 Nov 2008 13:30:20 +1100, Tom Krieg <"Please use   
   the website contact form"> wrote:   
      
   >Let's split the number into 2 parts, the "fixed" part (i.e. 4321, 4322   
   >etc) and the "increment" part (1,2,3,4).   
   >   
   >My suggestion is to create a table with 2 fields, "Fixed" and "Last   
   >Increment", where "fixed" is the primary key.   
   >   
   >When you create a new key, create a new record in this table and set the   
   >increment to 1. When you create another record for the same "fixed"   
   >part, just qlocate the appropriate record using a tcursor and add 1 to   
   >the increment.   
   >   
      
   Hi again,   
      
   Many thanks...   
      
   All the best,   
   --   
   Kenneth   
      
   If you email... Please remove the "SPAMLESS."   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)