Autonumber query

[arvindn]

I have very little experience using autonumber field. I have come to know that autonumber field may not follow the order of insertion. Is it possible?

To illustrate consider a table (auto-id(autonumber),name)
When the first record is added it contains

1,Arvind
2,Jay
3,Rahul.

So, for m & n, m<n can the mth record created have autoid greater than that of tha nth record created?

Coz it can create some problems with some key reordering that i do with temporary tables having autonumbers.

Thanks in advance.

 

[Mile-O]

If the field is so important for your structuring then ask yourself: "why am I using an autonumber to perform this?"

Autonumbers are best used just to give records a unique ID.

 

[arvindn]

Thanks for replying.

My reply to ur question is that i had just thought of using a simple method to achieve my objective. I can and probably will use recordsets for the same purpose henceforth but i would still like to know.

 

[arvindn]

Thanks a lot Pat. So, i do not need to change my method.

By the way, some digging up on my own has revealed that insertion from another table may cause the gaps to be filled in if u desire. But, as u said keeping a separate untouched field with newvalues to increment is a safe method which is what i wanted to know.

Thanks once again.

 

[arvindn]

Thanks a lot Pat, for the info. I understand ur point and it is valid.