how do I insert new DB records between existing records

how do I insert new DB records between existing records

Post by ZGVubmlzc » Tue, 07 Dec 2004 12:49:02


I am setting up a DB and it uses auto numbering for the first field. I would
like to add a DB record between existing records. When I click on "add new
record" it automatically sends me to the end of the list of records. How do
I insert a record between 2 existing autonumbering records?
 
 
 

how do I insert new DB records between existing records

Post by Rick Brand » Tue, 07 Dec 2004 12:58:18


You can't. Tables actually have no particular order. You could use your own
numbering system instead of using an AutoNumber. In your own system you could
number 10, 20, 30 , etc.. This would allow you to then add a record with the
number 15 if you wanted it to show as the second record in a query, form, or
report that was sorted on that field.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

 
 
 

how do I insert new DB records between existing records

Post by Jeff Boyc » Tue, 07 Dec 2004 21:52:58

In addition to Rick's comments, I would add ...

Define "between". Do you mean with a date/time field value between your two
records' values? Or between two "numbering" record values? As Rick points
out, you can't "insert" an Autonumber between 00001 and 00002.

And if you are using the Autonumber field as designed, you would NOT want to
"bump" the 00002 record (and every record above it) up by one to insert a
new record -- that could potential mess with any "child" records you had in
other tables.

There would be no reason you couldn't keep your Autonumber ID field, and add
a "sequence/sort" number field like Rick mentioned.

--
Good luck

Jeff Boyce
<Access MVP>



would
do