I should have stated that in this case I cannot use the autonumber feature. The field is part of a key that must be unique, so for other reasons as well, I need to add to the counter without using autonumber. How can this be done????
I assume that this is what you are trying to do:<BR><BR>Composite Key:<BR> FirstPart - Text or whatever<BR> UniquePart - The subject of your question<BR> LastPart - Text or Whatever<BR><BR>If you are convinced that you cannot use autonumber then you will need to setup a new Table and control the numbering from there..... can get messy with multiple users.<BR><BR>OR !!!!!!<BR><BR>How about defining a dummy field called DUMMYSEQ in the current table with a definition of Autonumber and then creating your composite key in the ASP code, viz:<BR><BR>CompositeKey = FirstPart & DUMMYSEQ & LastPart<BR><BR>R