Does the incremental part of the key revert back to 1 when the other   
   part changes? I.e. when the other part of the key changes to 4322, does   
   the sequence revert back to 43221, 43222, etc?   
      
   If that's the case, I would suggest a table with a record for every   
   generated key (4321, 4322 etc) being the primary key with a field   
   containing the last incremental number used for that main number.   
      
   Kenneth wrote:   
   >   
   > The value in the field in question is part of the key. The   
   > other part of the key is generated using code that is sound.   
   > (It takes a value from a table reserved for the purpose,   
   > adds one to that value, uses it as the first part of the   
   > key, and then puts the value back into the table.)   
   >   
   > I am trying to learn of the best way to assign the value of   
   > the field to a "1" or "2" etc. (so that the key generated   
   > would look something like 43211, 43212, 43213, 43214 etc.   
   > where the last digit is the one from the field I have   
   > described.   
   >   
   > Might you have ideas about that specific need?   
   >   
   > Many thanks,   
      
      
   --   
   Tom Krieg   
      
   ---------------   
   http://www.krieg.com.au   
   Please use the contact page to contact me via email   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)