>>>>Most people I know recommend the stored last ID & increment by 1. You could create a 1 record table with many fields -- each field is
>>>>another code holder.
>>>
>>>Or you could create a 1 field table with many records, which is the method I use....
>>
>>Is it 6 or a 1/2 dozen? (eg)
>>
>>Tom
>
>I think there is a difference here, though. I have a class that allows you to register a new file with the stored table. (Actually, it's a two-field table.) That way, you can just insert another record. If you only have one record, you have to ALTER TABLE. Also, if two people are working on different tables, they don't have to wait for an RLOCK to be released.
Yeah, but the "1/2 dozen" is you don't have to do a search to find the right record! (s)
Tom