From: usenet@soleSPAMLESSassociates.com   
      
   On Sat, 08 Nov 2008 11:35:39 +1100, Tom Krieg <"Please use   
   the website contact form"> wrote:   
      
   >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.   
      
   Hi again,   
      
   Yes, the incremental part was to revert back to "1."   
      
   As it happens, I have another approach that has solved my   
   problem, but I am still curious about your suggestion above.   
      
   But, with regret, I do not understand your suggestion as   
   written.   
      
   Could you please describe the idea in that closing paragraph   
   another way?   
      
   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)