Re: autonumber
From: fredg (fgutkind_at_example.invalid)
Date: 07/21/04
- Next message: John Vinson: "Re: 250 fields"
- Previous message: Delf: "autonumber"
- In reply to: Delf: "autonumber"
- Next in thread: John Vinson: "Re: autonumber"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 04:32:07 GMT
On Tue, 20 Jul 2004 21:13:39 -0700, Delf wrote:
> You know how access gets rid of an autonumber when
> deleting a record. Well is there anyway to recuperate
> those numbers to avoid from having too many gaps? and
> that also the number can match the scrolling number down
> on my scroll bar?
> Tx
Why would you want to re-use missing AutoNumbers? The purpose of
AutoNumber is to provide a unique number to assure Parent-Child record
relationship accuracy. It should be irrelevant whether the numbers are
consecutive or not. If you wish to have some sort of consecutive
record numbering, you'll need to create your own, but even then, if
you delete a record you'll have a gap. It really doesn't matter!
-- Fred Please only reply to this newsgroup. I do not reply to personal email.
- Next message: John Vinson: "Re: 250 fields"
- Previous message: Delf: "autonumber"
- In reply to: Delf: "autonumber"
- Next in thread: John Vinson: "Re: autonumber"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
